NULL and false in SQL

NULL and false is not the same in SQL.
Any comparison to NULL returns NULL instead of true and false.
field IS NULL will return true/false.