Mega Code Archive

 

Categories / MSSQL Tutorial / Data Types

 

Using convert to convert integer to characters

4> 5> SELECT CONVERT(char(4), 2005) + ' Can now be concatenated!' 6> GO ----------------------------- 2005 Can now be concatenated! (1 rows affected)