IS NULL Predicate
Use the IS NULL predicate to determine whether an expression is null, because you cannot test for null by using the = comparison operator.
The IS NULL predicate takes the following form:
IS [NOT] NULL
For example:
x IS NULL
is true if x is a null.