nvl function

Applies to: Databricks SQL Databricks Runtime

Returns expr2 if expr1 is NULL, or expr1 otherwise. This function is a synonym for coalesce(expr1, expr2) with two arguments.

Syntax

nvl(expr1, expr2)

Arguments

• expr1: An expression of any type.
• expr2: An expression that shares a least common type with expr1.

Returns

The result type is the least common type of the argument types.

Special considerations apply to VARIANT types. See isnull function for details.

Examples

> SELECT nvl(NULL, 2);
 2

> SELECT nvl(3, 2);
 3

Related functions

• coalesce function
• ifnull function
• nvl2 function