Selecting where row value is null

Posted by Jamsi in SQL on December 8th, 2006 | no responses

Don’t ask me why, but I ALWAYS forget how to select results from an mSQL database where the value is null. It’s just weird.

I always try

select * from table where colname = null
or
select * from table where colname = ”

But the correct way is to select using IS NULL!

select * from table where colname IS NULL

No related posts.