IfNullNumeric

Returns the given number, or the default number when the given value is null.

Numeric IfNullNumeric(Numeric value = null, Numeric defaultValue = 0)

Returns 20 because the value is null.

SELECT IfNullNumeric(null, 20) + 10 as Result FROM Single

• Scalar Functions