Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query optimization, and usability that you won’t want to miss.

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 |
+--------------+-----------+--------------------+-------------+