The CONCAT_WS String Function in SQL Server 2017

The CONCAT_WS String Function in SQL Server 2017 is a new function that provides more flexibility for string operations. Definition CONCAT_WS concatenates a variable number of arguments setting as a delimiter the first argument in the function. Examples Before checking out some examples of using CONCAT_WS, let’s create a temporary table with some sample data: CREATE TABLE … Read more…