Using CONACTE_WS() Function with NULL values

SQL Server CONCAT_WS() function is a string function that is used concatenates two or more strings together with a separator.

It separates those concatenated string values with the delimiter specified in the first function parameter.