IS [NOT] NULL
Determines if an expression is NULL or not NULL. Alias for the function ISNULL/ISNOTNULL.
Syntax
IS [NOT] NULL(expression any) → boolean
expression: Expression of any Spice supported data type to evaluate.
Examples
SELECT ISNULL('SPICE')
-- False
SELECT 'SPICE' IS NULL
-- False
IS [NOT] NULL(expression any) → boolean
expression: Expression of any Spice supported data type to evaluate.
Examples
SELECT ISNOTNULL('SPICE')
-- True
ISNOTNULL operator returns true if <expression> is not NULL, and false otherwise.
SELECT 'SPICE' IS NOT NULL
-- False
Last updated
Was this helpful?