NOT IsNull(EmailAddress,'') <> '' 1

[onressy]

Helo,
currently i have this:
strWhereClause = " EmailAddress <> '' AND NOT EmailAddress IS NULL"

Trying to write it more effieciently, something like this (which isn't working?)

NOT IsNull(EmailAddress,'') <> ''

Thanks

 

[DotNetGnat]

that might be because all the white spaces you are seeing may not be spaces...they can be line feed or tabs...

so you need to check for all of these characters...

-DNG

 

[damber]

In what way is it not working ?

try removing the NOT from the beginning, as this negates the <> operator, reversing the check of '' and '' being equal... returning true when Email is null or '' - hard to tell if this is what you want as you do it the opposite way in the first statement

A smile is worth a thousand kind words. So smile, it's easy!