Checking database for NULL boolean value Checking database for NULL boolean value sql sql

Checking database for NULL boolean value


In TSQL, you need to use IS rather than = when comparing with NULL:

SELECT * FROM table WHERE field IS NULL


Try

select * from table where field IS null


You want IS NULL I believe:

SELECT * FROM table WHERE field IS NULL