Function name is CONCAT_WS which is launched in SQL Server 2017 version. Now come to functional part its takes a variable number of arguments and concatenates them in single string by using the first argument as separator. This will requires separator and a minimum of two arguments.
And this function is very helpful in creating a comma or pipe separated csv file content.
