Skip to main content

Coalesce Function

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

FunctionParametersDescription
COALESCEvalue (any number of values may be provided)

Returns the first value that is not NULL.

If all values are NULL, returns NULL.