Was this helpful?
IS NULL Predicate
Use IS NULL to determine whether an expression is null, because you cannot test for null by using the = comparison operator. When applied to row value expressions, all elements must test the same.
The IS NULL predicate takes the following form:
IS [NOT] NULL
For example:
x IS NULL
is true if x is a null.
IS UNKNOWN is a synonym for IS NULL when the expression is of the BOOLEAN type.
Last modified date: 11/28/2023