ISNUMERIC and Floating Point 1

[andrewwatson]

If you pass ISNUMERIC a string containing a floating point number in scientific format (eg 1.23E4), it returns 1 (i.e. it is a number). However, if you then try to convert (explicit or implicit) this string to Decimal , you get a data conversion error.

Is there any way of converting such numbers easily (I'd rather not have to scan the string for "E"s and multiply by powers of ten if I can avoid it.

 

[tlbroadbent]

You can convert the character string to float and then to decimal.

Select
DecNum=convert(decimal(20,10), convert(float, FloatNum))
From tablename Terry L. Broadbent - DBA
Computing Links:

http://tlbroadbent.home.attbi.com/prog.htm

faq183-874 contains "Suggestions for Getting Quick and Appropriate Answers" to your questions.

 

[andrewwatson]

Doh! So obvious in hindsight. Thanks.