Concat :- New function in sql server denali

SQL Server Denali has many new programming function
We will look at it one by one

Concat

Returns a string that is concaconcatenating  of two or more string values