![]() Previous |
![]() Next |
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.