Get started
Load & manage data
Work with data
Administration
Reference & resources
CLUSTER BY
mask
ROW FILTER
Updated Mar 19, 2024
Send us feedback
isnotnull
Applies to: Databricks SQL Databricks Runtime
Returns true if expr is not NULL. This function is a synonym for expr IS NOT NULL.
true
expr
NULL
expr IS NOT NULL
isnotnull(expr)
expr: An expression of any type.
A BOOLEAN.
> SELECT isnotnull(1); true
isnull function
isnan function
is null operator