How to use the COALESCE function in SQL Server

The Coalesce Academy: The Complete Series coalesce COALESCE The COALESCE() function produces the first non- NULL value from the variadic list of arguments SELECT coalesce How To Use the COALESCE SQL Function · The function evaluates the expressions received as input from left to right · It returns the first non- NULL expression

coalesce The COALESCE expression allows for user-specified NULL-handling It is often used to fill in missing values in dirty data