Collections:
CONVERT() - Converting Character Strings to Numeric Values in SQL Server
How To Convert Character Strings into Numeric Values in SQL Server Transact-SQL?
✍: FYIcenter.com
Sometimes you need to convert numeric values enclosed in character strings back to numeric values by using the CONVERT() function.
When converting character strings to values with CONVERT(), you need to remember two rules:
The tutorial exercise below shows you how to use the CONVERT() function to convert strings to values:
SELECT CONVERT(NUMERIC(10,5), ' 12345.12 '); GO 12345.12000 -- Input does not match the target data type SELECT CONVERT(INT, '12345.12'); GO Msg 245, Level 16, State 1, Line 1 Conversion failed when converting the varchar value '12345.12' to data type int. -- Input does not match the target data type SELECT CONVERT(NUMERIC(10,5), '12345.12E+00'); GO Msg 8114, Level 16, State 5, Line 1 Error converting data type varchar to numeric. -- Double conversion works SELECT CONVERT(NUMERIC(10,5), CONVERT(FLOAT(24), ' 12345.12E+00 ')); GO 12345.12012 SELECT CONVERT(FLOAT(24), ' 12345.12E+00 '); GO 12345.12
⇒ Overflow Errors on Converting Big Values to Integers in SQL Server
⇐ CONVERT() - Converting Numeric Expression Data Types in SQL Server
⇑ Numeric Expressions and Functions in SQL Server Transact-SQL
2017-03-22, 3262🔥, 0💬
Popular Posts:
What is test testing area for? The testing area is provided to allow visitors to post testing commen...
What is test testing area for? The testing area is provided to allow visitors to post testing commen...
How to execute statements in loops in SQL Server Transact-SQL? How to use WHILE ... loops? You can u...
Is PL/SQL Language Case Sensitive in Oracle? PL/SQL language is not case sensitive: Reserved words a...
Is SQL Server Transact-SQL case sensitive? No. Transact-SQL is not case sensitive. Like the standard...