This is a very basic SQL question. You need to go get a good book on
SQL. I recommend the pink book. (you'll understand when you see it)
To answer your question: IS NULL not = NULL. But please don't take
my answer and fail to purchase a good book on SQL.
On Apr 24, 2009, at 11:22 PM, Matt Hoover wrote:
In query builder - how do I search on dates that are NULL? I have
tried Told = NULL and lots of other combinations... We are using RT
3.81
Thanks
Matt
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [email protected]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
--
Jo Rhett
Net Consonance : consonant endings by net philanthropy, open source
and other randomness
_______________________________________________
http://lists.bestpractical.com/cgi-bin/mailman/listinfo/rt-users
Community help: http://wiki.bestpractical.com
Commercial support: [email protected]
Discover RT's hidden secrets with RT Essentials from O'Reilly Media.
Buy a copy at http://rtbook.bestpractical.com
