Get started
Load & manage data
Work with data
Administration
Reference & resources
Updated Oct 03, 2023
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