NullToValue function

Returns zero if the input column is null, otherwise returns the input column value.

Namespace

Global. No namespace qualifier required.

Input

Column value (object/expression)

Output

Column value or zero.

Example

If a contains the null, b contains string value, and c contains the number 999, then If the input column does not contain a null, the output column contains the value of the input column. If the input column does contain a null, then the output column contains the string null. In the below examples, col1 is 42, col2 is 42, and col3 is 999.