COALESCE

Returns the first value in a given list that is not null.

Syntax

COALESCE(VALUE1, VALUE2[, ...])

Arguments

VALUE

Type: any

A list of values of any type.

Returns

Type: same as input

The first VALUE that is not null.