Page 1 of 1

Stupid Question I'm Sure - Can you Query based on NULL

Posted: Sun Sep 21, 2008 10:09 am
by rbc
I have a situation that I'd like to search a DB table to find those that have a NULL value.

Code: Select all

SELECT * FROM table_name WHERE columnA=NULL
Is something like this doable? If not, is there a work around? Thanks!

Re: Stupid Question I'm Sure - Can you Query based on NULL

Posted: Sun Sep 21, 2008 10:11 am
by rbc
Totally stupid. Knew it was. Just use IS NULL. Please delete this useless post.