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