The NULL predicate can be used for testing null values of database table columns.

Syntax

This is the syntax for a NULL predicate

column_name IS [ NOT ] NULL

Example

contact_name IS NOT NULL