Convert Int to String

There are two different functions that can be used when converting an integer to a string. One is CAST and the other is CONVERT. Either of these functions can be used with the exact same result when converting to a string. The only difference with the CONVERT function is that it takes an extra optional parameter for style which can affect the way certain data types are displayed after they are converted (an example is with date/time formats).

The common need to convert an INT to a string is to then concatenate it with either another int or an existing string.

Here is a simple example:
[cc lang=”sql”]
And the output:

Here we are casting the int to a varchar(11). This is a safe value for us to convert to because the maximum integer value is -2147483648.

We see if we try to convert an integer to a smaller string, it returns back an asterisks (*) meaning an error has occurred.
[cc lang=”sql”]
SELECT CAST(-2147483648 AS VARCHAR(10))

So it is important to choose a data type that is large enough.

With that said, I have seen the following work as well, however I personally would not run this in production in case it is deprecated in a future version of SQL.

[cc lang=”sql”]

Martin 19 Sep 2018 at 1:09 pm

It seems to me that this article is not finished. It starts out by saying there are two different functions, but then only exemplifies CAST, ignoring CONVERT

Jeremy 01 Jun 2018 at 11:18 am

Good one, very handy

Marcus Caixeta 10 Jan 2018 at 4:52 pm

Thank you, I am Brazilian, you help me a lot.

Featured Articles

 Site Author

  • Thanks for visiting!