Dremio Cloud
Dremio Software
 
On this page

    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

    ISNULL function returns true if <expression> is NULL, and false otherwise. 
    SELECT ISNULL('dremio')
-- False
    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

    ISNOTNULL function returns true if <expression> is not NULL, and false otherwise. 
    SELECT ISNOTNULL('dremio')
-- True
    ISNOTNULL operator returns true if <expression> is not NULL, and false otherwise. 
    SELECT 'dremio' IS NOT NULL
-- False