COALESCE

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

Syntax

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

Parameters

Parameter Description Supported 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