Coalesce Function

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

Function	Parameters	Description
COALESCE	value (any number of values may be provided)	Returns the first value that is not NULL. If all values are NULL, returns NULL.