Categories: Conditional, Boolean

ISNULL

Determines if an expression is NULL. Returns true if is NULL, and false otherwise. Alias for the operator IS NULL.

Syntax

ISNULL(expression Any type) → boolean

  • expression: Expression of any type to evaluate.

Examples

select ISNULL('dremio')
-- False
select 'dremio' IS NULL
-- False