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 ...

This function returns a string resulting from the concatenation, or joining, of two or more string values in an end-to-end manner. It separates those concatenated string values with the delimiter ...

The full form of CONCAT_WS is concatenate with Separator which is a special form of CONCAT(). The first argument in CONCAT_WS is used as a separator for concatenate all other arguments. The separator ...