COALESCE - SQL Server

Understanding SQL Server COALESCE with Empty Strings coalesce Usage · coalesce expression simplifies standard SQL expressions by allowing you to express a search condition as a simple comparison instead of using a when coalesce The COALESCE function returns the first non-null expression in a list of expressions

coalesce Coalesce returns the first non-null value in a list If all the values in the list are NULL, then the function returns null