IS [ NOT ] NULL
Determines whether an expression is NULL or is not NULL.
Syntax
Section titled “Syntax”<expr> IS [ NOT ] NULLReturns
Section titled “Returns”Returns a boolean.
- When IS NULL is specified, the value is TRUE if the expression is NULL. Otherwise, returns FALSE.
- When IS NOT NULL is specified, the value is TRUE if the expression is not NULL. Otherwise, returns FALSE.