You are viewing an older version of this section. View current production version.
Join the SingleStore Community Today
Get expert advice, develop skills, and connect with others.

ISNULL

Returns true if the value is NULL.

Syntax

ISNULL (val)
(val IS NULL)

Arguments

  • val: any object

Return Type

Boolean

Examples

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