Back to cookbooks list Articles Cookbook

How to Convert an Integer to a Decimal in SQL Server

  • CAST()


You’d like to convert an integer value to a DECIMAL data type in SQL Server.

Let’s convert an integer to the DECIMAL data type.

Solution 1:

We’ll use the CAST() function. Here’s the query you’d write:

  CAST(12 AS DECIMAL(7,2)) AS decimal_value;

Here is the result:



Use the CAST() function to convert an integer to a DECIMAL data type. This function takes an expression or a column name as the argument, followed by the keyword AS and the new data type. In our example, we converted an integer (12) to a decimal value (12.00). The displayed value has two decimal points because DECIMAL in CAST() has two decimal points.

SQL Server provides another option: CONVERT(). This is not a SQL Standard function like CAST(). The query below shows its use.

Discover the best interactive SQL Server courses

Solution 2:

Here’s another way to convert an integer to a DECIMAL type:

  CONVERT(DECIMAL(7,2), 12) AS decimal_value;

This query produces the same result as CAST(), but takes two mandatory arguments: the data type and an expression, value, or column name to convert. An optional third parameter specifies how the value should be formatted in its new type. Read more about value formatting in the official SQL Server documentation.

If you don’t need to return the value in a certain format, use CAST().

Recommended courses:

Recommended articles:

See also: