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 |
|
fisherman_jake
Slave to the Almighty Yak
159 Posts |
 Posted - 2001-12-30 : 22:33:01
|
G'day, just a quick one, maybe one of the super gurus would know why this is returning TRUE when it is definitely FALSE.. --<TSQL>--select isnumeric('516D10')--<TSQL>-- Thanks in advance..==================================================World War III is imminent, you know what that means... No Bag limits!!!Master Fisherman |
|
|
izaltsman
A custom title
1139 Posts |
Posted - 2001-12-30 : 23:03:22
|
| IsNumeric is funky that way... I've heard a rumor that this has something to do with the fact that 999D999 was a valid numeric format in Fortran (might have been used for recording numbers in exponential form or something). So Microsoft decided that IsNumeric function in SQL Server should recognize it. Unfortunately developer responsible for coding up CAST/CONVERT "didn't get that memo." Therefore even though isnumeric says it's a number, you will not be able to use it in any calculations or assign to numeric variables. Unfortunately I know nothing about Fortran, so I can't really confirm. Edited by - izaltsman on 12/30/2001 23:19:37 |
 |
|
|
Arnold Fribble
Yak-finder General
1961 Posts |
Posted - 2002-01-01 : 14:11:01
|
| CONVERT(float, '516D10')returns the same result asCONVERT(float, '516E10') |
|
|
|
|
|
|
Why is ISNUMERIC failing