nanvl function

Applies to: Databricks SQL Databricks Runtime

Returns expr1 if it's not NaN, or expr2 otherwise.

Syntax

nanvl(expr1, expr2)

Arguments

• expr1: An expression that evaluates to a numeric.
• expr2: An expression that evaluates to a numeric.

Returns

A DOUBLE.

Examples

> SELECT nanvl(cast('NaN' AS DOUBLE), 123);
 123.0

Related functions

• coalesce function