IS__NOT__NULL

Categories: Boolean, Datatype

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 Dremio supported data type to evaluate.

Examples

{{< codeheader "ISNULL function returns true if <expression> is NULL, and false otherwise." >}}

SELECT ISNULL('dremio')
-- False

{{< codeheader "ISNULL operator returns true if <expression> is NULL, and false otherwise." >}}

SELECT 'dremio' IS NULL
-- False

IS [NOT] NULL(expression any) → boolean

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

Examples

{{< codeheader "ISNOTNULL function returns true if <expression> is not NULL, and false otherwise." >}}

SELECT ISNOTNULL('dremio')
-- True

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

SELECT 'dremio' IS NOT NULL
-- False