SQL Server CONCAT_WS Function

Example

Add strings together. Use ‘.’ to separate the concatenated string values:

SELECT CONCAT_WS('.', 'www', 'iampsp', 'com');

Definition and Usage

The CONCAT_WS() function adds two or more strings together with a separator.

 

Syntax

CONCAT_WS(separator, string1, string2, ...., string_n)

Continue reading SQL Server CONCAT_WS Function