is-not-null.md

description
Determines if an expression is NULL or not NULL. Alias for the function ISNULL/ISNOTNULL.

IS [NOT] NULL

Syntax

IS [NOT] NULL(expression any) → boolean

• expression: Expression of any Spice supported data type to evaluate.

Examples

{% code title="ISNULL function returns true if is NULL, and false otherwise." %}

SELECT ISNULL('SPICE')
-- False

{% endcode %}

{% code title="ISNULL operator returns true if is NULL, and false otherwise." %}

SELECT 'SPICE' IS NULL
-- False

{% endcode %}

IS [NOT] NULL(expression any) → boolean

• expression: Expression of any Spice supported data type to evaluate.

Examples

{% code title="ISNOTNULL function returns true if is not NULL, and false otherwise." %}

SELECT ISNOTNULL('SPICE')
-- True

{% endcode %}

ISNOTNULL operator returns true if <expression> is not NULL, and false otherwise.

{% code title="ISNOTNULL operator returns true if is not NULL, and false otherwise." %}

SELECT 'SPICE' IS NOT NULL
-- False

{% endcode %}