coalesce

Returns the first non-null expression in a list

Syntax

COALESCE(value_expr1, value_expr2, ... value_expr_n)

Arguments

value_expr1

Expressions to be evaluated.

Description

This system function returns the first non-NULL expression from the specified list of expressions. If all expressions in the list are NULL, the function returns NULL.