is null
operator
Applies to: Databricks SQL Databricks Runtime
Tests whether expr
is NULL
.
Returns
A BOOLEAN
.
If not
is specified this operator is a synonym for isnotnull(expr)
.
Otherwise the operator is a synonym for isnull(expr)
.
If expr
is a VARIANT
result of a:
JSON path expression with a valid path,
the result of is null
is always false
.
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
.