Part 1 of this article introduced four new T-SQL functions available in SQL Server 2012. Part 2 has the rest.

The CONCAT function produces a character matrix containing elements that are the concatenations of corresponding element strings from each argument. The CONCAT function accepts up to 15 arguments, ...