How to convert Number into String in Stored Procedure

Question

I have numbers and i want to convert those number into string in the stored procedure.

Please reply.

Thanks !

Possible duplicate of [Convert INT to VARCHAR SQL](http://stackoverflow.com/questions/19979532/convert-int-to-varchar-sql) — marcelovca90, Dec 16 '16 at 13:39
https://www.google.com/?q=sql+server+convert+number+into+string — James Z, Dec 19 '16 at 20:49

score 12 · Accepted Answer · answered Dec 16 '16 at 13:41

12

Without knowing what database you're using, we cannot give an exact syntax. Here's the syntax for MSSQL:

CAST(column AS VARCHAR(10))

Or

CONVERT(VARCHAR(10), column)

answered Dec 16 '16 at 13:41

negacao

For me CONVERT(VARCHAR(10), column) worked but I needed to use VARCHAR(50) as I am dealing with international telephones with many formats. – Aggie Jon of 87 Jan 25 '22 at 18:04

score 1 · Answer 2 · answered Dec 16 '16 at 13:40

A conversion in T-SQL can be done with the CAST function. A sample can be:

SELECT CAST(myNumber AS VARCHAR) FROM myTable

where myNumber is your numeric field, and myTable the table in which the field is present. A cast can be used as a parameter for joins too.

Another function you can use is STR:

SELECT STR(myField) FROM myTable

2 Answers2