Neoview SQL Reference Manual (R2.2)

ZEROIFNULL Function
The ZEROIFNULL function returns a value of zero 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)
434 SQL Functions and Expressions