nullifzero
function
Applies to: Databricks Runtime 16.0 and later
Returns NULL
if expr
is 0
, or expr
otherwise. This function is a synonym for if(expr = 0, null, expr)
.
nullifzero(expr)
expr
: A numeric expression orNULL
.
The result type is the same as the type of expr
.
> SELECT nullifzero(0);
NULL
> SELECT nullifzero(NULL);
NULL
> SELECT nullifzero(5);
5