Was this helpful?
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.
Last modified date: 12/14/2023