Using the SQL Coalesce function in SQL Server

Mastering the COALESCE Function in SQL coalesce The COALESCE function returns the first non-NULL value from a series of expressions coalesce Example COALESCE takes any number of arguments and returns the first non-null one

coalesce COALESCE The COALESCE() function produces the first non- NULL value from the variadic list of arguments SELECT