SQL Server concat_ws function available starting 2017: Concat_ws is a new function introduced in sql server 2017. Syntax: CONCAT_WS ( separator, argument1, argument1 [, argumentN]… ) Concat_ws will take the separator as the first argument and will then concatenate variable number of argument into a single string. You will need a separator and minimum of