How do I use the CONCAT function in SQL Server 2008 R2?

Just for completeness – in SQL 2008 you would use the plus + operator to perform string concatenation.

Take a look at the MSDN reference with sample code. Starting with SQL 2012, you may wish to use the new CONCAT function.