Skip to main content

IS [ NOT ] NULL

Determines whether an expression is NULL or is not NULL.

Syntax​

<expr> IS [ NOT ] NULL

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.
On this page