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