Hello,
thanks, and you're probably right.
There wasn't a space entered, but it is an empty field.
Is there any way to display the records with an empty field, along
with the records returned by the Custom SQL?

--- In briousers@yahoogroups.com, Average Guy <flyin4thetop@...> wrote:
>
> Hello,
>
> Well when working with nulls, the thing to remember is that a null
value is where a value could have been entered but a space was entered
instead. It sounds like you may have fields that have blanks value
entered, meaning, it is not null, it an empty string.
>
>
> nyphoto01 <nyphoto01@...> wrote:
> Hi everyone.
> I just wanted to say hi first, as I am a recent member of your group.
> I need desperate help with the "include nulls" options in Limits. Why
> does it not work (it doesn't show blanks)?
> I am using it on a Date Limit, which I have set as Custom SQL of > {
> fn CURDATE()} (it shows me all records where the date is greater than
> today).
> However, I want it to also show me records where there is no date.
> Can you help?
>
> Thank you