Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
imsganesh
Starting Member
28 Posts |
 Posted - 2006-01-17 : 16:26:09
|
| Hi...I'm trying to convert the varchar field to numeric. I'm using the isnumeric() function before converting it. still the query is failing when it is trying to convert this type of value '1.22252e+006' (values with exponent character), which is still recognised by the isnumeric function as a number. I donno whether this is known issue. Is there any patch/workaround for this problem?Thanks in advance!SGGanesh |
|
|
Srinika
Master Smack Fu Yak Hacker
1378 Posts |
Posted - 2006-01-17 : 16:34:52
|
| Print convert(Float, '1.22252e+006' ) Print convert(Float, '1.22252e+006' ) / 1000000 |
 |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2006-01-17 : 17:27:13
|
| cross posthttp://sqlteam.com/forums/topic.asp?TOPIC_ID=60425 |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
imsganesh
Starting Member
28 Posts |
Posted - 2006-01-18 : 15:08:39
|
| Thanks to you all! |
|
|
|
|
|
|
Error in converting to numeric!