COALESCE

Reference material for COALESCE function

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