nullif function

Applies to: Databricks SQL Databricks Runtime

Returns NULL if expr1 equals expr2, or expr1 otherwise.

nullif(expr1, expr2)

• expr1: An expression of any type.
• expr2: An expression of the same type as expr.

NULL if expr1 equals to expr2, or expr1 otherwise.

> SELECT nullif(2, 2);
 NULL

> SELECT nullif(2, 3);
 2

• coalesce function
• decode (key) function
• case expression