SQL Server Transact Basic to Expert - Concantenate Integer and string in SQL Query

This blog shows how to concantenate an integer and a string using SQL query

Example:

SELECT CONVERT(char(4), 2011) + ' - This is Current Year'

The expected result would be 2011 - This is Current Year