Outdated Version

You are viewing an older version of this section. View current production version.

ISNULL

Returns true if the value is NULL.

Syntax

ISNULL (val)
(val IS NULL)

Arguments

  • val: any object

Return Type

Boolean

Examples

select isnull(NULL), isnull(0), (NULL + 0 is NULL), (0 is NULL);
+--------------+-----------+--------------------+-------------+
| isnull(NULL) | isnull(0) | (NULL + 0 is NULL) | (0 is NULL) |
+--------------+-----------+--------------------+-------------+
|            1 |         0 |                  1 |           0 |
+--------------+-----------+--------------------+-------------+