equal_null
function
Applies to: Databricks SQL
Databricks Runtime 11.1 and above
Returns true
if expr1
equals expr2
or both expressions are NULL
, or false
otherwise.
Arguments
expr1
: An expression of any comparable type.expr2
: An expression sharing a least common type withexpr1
.
Returns
A BOOLEAN.
This function differs from = (eq sign) operator, by treating NULL
as a comparable value.