equal_null
function
Applies to: Databricks SQL Databricks Runtime 11.3 LTS and above
Returns true
if expr1
equals expr2
or both expressions are NULL
, or false
otherwise. This function differs from = (eq sign) operator, by treating NULL
as a comparable value.