| Value of arg | ZEROIFNULL Value Returned |
|---|---|
| Not null | Value of the numeric argument. |
| Null or zero | Zero. |
If the argument is not numeric, the value is converted to a numeric value according to implicit type conversion rules. If the argument cannot be converted, an error is reported. For more information, see Data Type Conversions.
If arg is a character string, the string is converted to a numeric value of FLOAT data type.
ZEROIFNULL cannot be applied to the following types of arguments:
- BYTE or VARBYTE
- BLOB or CLOB
- CHARACTER or VARCHAR if the server character set is GRAPHIC