Having problems with message search?
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
Be a better sports nut! Let your teams follow you with Yahoo Mobile. Try it now.
Offline 
Send Email