isnotnull
function
Applies to: Databricks SQL Databricks Runtime
Returns true
if expr
is not NULL
. This function is a synonym for expr IS NOT NULL
.
Returns
A BOOLEAN
.
If expr
is a VARIANT
result of a:
JSON path expression with a valid path,
the result is always true
.
Use the is_variant_null function function to check if the VARIANT
encoded value is NULL
, or cast the VARIANT
to a specific type and check if the result is NULL
.