NANVL

NANVL checks if a value is a number. If it is, then NANVL returns that value. If not, it returns an alternate value. This function is typically used to convert a binary double or binary float NaN (Not a Number) value to zero or null.

Return Value

datatype

Syntax

NANVL (expression, alternate)

Arguments

expression can be any value.

alternate is the numeric value returned if expression is not a number.