Retrieve the initial non-null value from a set of options.
| SELECT COALESCE(NULL, NULL, NULL, ‘W3Schools.com’, NULL, ‘Example.com’); |
The COALESCE() function returns the first non-null value in a list.
| COALESCE(val1, val2, …., val_n) |
|
Parameter |
Description |
|
val1, val2, val_n |
Mandatory. The list of values to evaluate for the first non-null occurrence. |
|
Works in: |
SQL Server (from 2008 onward), Azure SQL Database, Azure SQL Data Warehouse, and Parallel Data Warehouse |
Retrieve the initial non-null value from a series of options.
| SELECT COALESCE(NULL, 1, 2, ‘W3Schools.com’); |