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

Examples

ISNULL function returns true if expression is NULL, and false otherwise.

SELECT ISNULL('TurboAssure')
-- False

ISNULL operator returns true if expression is NULL, and false otherwise.

SELECT 'TurboAssure' IS NULL
-- False

IS [NOT] NULL(expression any) → boolean

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

Examples

ISNOTNULL function returns true if expression is not NULL, and false otherwise.

SELECT ISNOTNULL('TurboAssure')
-- True

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

SELECT 'TurboAssure' IS NOT NULL
-- False