Coalesce Function

AMPS includes a function that accepts any number of arguments and returns the first argument that is not NULL.

COALESCE

COALESCE

---

COALESCE(value, [value, ...])

Returns the first value that is not NULL.

Parameters

• value: One or more values to check.

Returns

The first value that is not NULL. If all values are NULL, returns NULL.