Selecting where row value is null

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.



Leave a Reply