xxxxxxxxxx
SELECT CAST(column_name AS CHAR) AS string_column
FROM table_name;
xxxxxxxxxx
Using the CONVERT function
The CONVERT function can also be used to convert an integer to a string. The syntax for this function is as follows:
synax: CONVERT (data_type [ (length) ], expression [, style ])
Here is an example to convert integer to string using CONVERT function:
>SELECT CONVERT(VARCHAR(10), 123456)