Conditional and miscellaneous functions
COALESCE
Reference material for COALESCE function
Checks from left to right for the first non-NULL argument found for each entry parameter pair.
Syntax
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
:
Returns: esimpson