CONCAT_WS (Transact-SQL) [!INCLUDE sqlserver2017-asdb-asdbmi-asa] This function returns a string resulting from the concatenation, or joining, of two or more string values in an end-to-end manner. It ...

Concatenate with separator. Returns a string resulting from the joining of two or more string values in an end-to-end manner. Uses the first argument as the separator between each string.