Important
Helios features are now enabled during weekly update windows and are no longer directly tied to SingleStore engine releases. Refer to the release notes to view the latest features available in your Helios cluster.
ISNULL
On this page
The ISNULL() function 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 |
+--------------+-----------+--------------------+-------------+Last modified: