NULLIFZERO
Applies to: ✅ Data 360 SQL ✅ Tableau Hyper API
Returns NULL when numeric input is zero; otherwise, returns input unchanged.
Syntax
Arguments
Required
<value>: Numeric expression to check.
Returns
Returns NULL for zero input; otherwise, returns input with its numeric type.
Considerations
- Requires exactly one numeric argument.
- NULL input returns NULL.
- Positive and negative zero, including
-0.0, return NULL.
- Untyped NULL input returns NULL.
Examples
Convert zero to NULL
Return NULL for a zero input.
1SELECT nullifzero(0) AS result;
Returns NULL.
Preserve a nonzero value
Return the input when it isn’t zero.
1SELECT nullifzero(42) AS result;
Returns 42.
Related Documentation
j