SQL Server Transact Basic to Expert - Concantenate Integer and string in SQL Query
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