xxxxxxxxxx
-- sql server
SELECT CONVERT(NVARCHAR(100), 10) AS Result
SELECT CONVERT(VARCHAR(100), 10) AS Result
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)