how to handle null value in string concatenation in sql server

SQL COALESCE() function returns the first non-null value in a list.