Checks from left to right for the first non-NULL argument found for each entry parameter pair.

Syntax

COALESCE(<expression> [,...])

Parameters

ParameterDescriptionSupported input types
<expression>The expression(s) to coalesce.Any

Return Types

Same as input type

Example

The following example returns the first non-NULL value provided, which is the username esimpson:

SELECT COALESCE(NULL, 'esimpson','sabrina21') AS nicknames;

Returns: esimpson