I just installed SQL Server 11 CTP3 in my machine and started to review new functionalities. One feature I learned is CONCAT(tsql function) which is used to concatenate two or more strings. This function requires 2 to 254 arguments.