4. Elements of OpenSQL Statements : Predicates : Is Null Predicate
 
Share this page                  
Is Null Predicate
The is null predicate takes the form:
IS [NOT] NULL
For example:
x IS NULL
is true if x is a null. Because you cannot test for null using the “=” comparison operator, the null predicate must be used to determine whether an expression is null.