SQL Server COALESCE() Function - W3Schools
https://www.w3schools.com/SQL/func_sqlserver_coalesce.asp
WebDefinition and Usage. The COALESCE () function returns the first non-null value in a list. Syntax. COALESCE ( val1, val2, ...., val_n) Parameter Values. Technical Details. More Examples. Example. Return the first non-null value in a list: SELECT COALESCE(NULL, 1, 2, 'W3Schools.com'); Try it Yourself » Previous SQL Server Functions Next .
DA: 94 PA: 87 MOZ Rank: 70