Home >> FAQs/Tutorials >> SQL Server FAQ

SQL Server FAQ - CAST() - Converting Numeric Expression Data Types

By: FYIcenter.com

(Continued from previous topic...)

How To Convert Numeric Expression Data Types using the CAST() Function?

If you want to convert the data type of a numeric expression to a new data type, you can use the CAST(expression AS data_type) function. The tutorial exercise below shows you how to use the CAST() function:

-- FLOAT converted to NUMERIC by CAST()
DECLARE @pi FLOAT(24);
SET @pi = 3.141592E+00;
SELECT CAST(@pi AS NUMERIC(5,2));
GO
3.14

-- FLOAT converted to NUMERIC by CAST()
DECLARE @x FLOAT(24);
SET @x = 12345.12E+00;
SELECT CAST(@x AS NUMERIC(10,5));
GO
12345.12305

-- FLOAT converted to INT by CAST()
DECLARE @x FLOAT(24);
SET @x = 12345.12E+00;
SELECT CAST(@x AS INT);
GO
12345

(Continued on next topic...)

1. What Is an Expression?
2. What Are Arithmetic Operators?
3. What Happens to an Arithmetic Operation with Two Different Data Types?
4. How To Convert a Numeric Expression from One Data Type to Another?
5. How To Convert Numeric Expression Data Types by Assignment Operations?
6. How To Convert Numeric Expression Data Types using the CAST() Function?
7. How To Convert Numeric Expression Data Types using the CONVERT() Function?
8. How To Convert Character Strings into Numeric Values?
9. What Happens When Converting Big Values to Integers?
10. What Happens When Converting Big Values to NUMERIC Data Types?
11. What Are the Mathematical Functions Supported by SQL Server 2005?
12. How To Convert Numeric Values to Integers?
13. How To Round a Numeric Value To a Specific Precision?
14. How To Generate Random Numbers with the RAND() Function?