Neoview SQL Reference Manual (R2.4 SP2)

ZEROIFNULL Function
The ZEROIFNULL function returns a value of zero if the expression if NULL. Otherwise, it
returns the value of the expression.
ZEROIFNULL (expression)
expression
specifies a value expression. It must be a numeric data type.
Example of ZEROIFNULL
ZEROIFNULL returns the value of the column named salary whenever the column value is not
NULL and it returns 0 whenever the column value is NULL.
ZEROIFNULL (salary)
ZEROIFNULL Function 477