Description
The NULL predicate can be used for testing null values of database table columns. This predicate can be used inside of a WHERE, HAVING, or JOIN statement.
Syntax
null_predicate ::
column_name IS [ NOT ] NULL
Example
contact_name IS NOT NULL
See also: