Convert & Cast Function

[Elmer Rivera]

Ive got a column with a value of 9e+09, how do i convert it to 90000000.00 as varchar?

[MAK]

you should create a function for that.

if its just the same format like 99e99 all the time, its easy to write
a small function. but if it follows the following standard, then its
a big function.


"0" [0,0,0]
"0.00" [0,0,0]
"123" [0,123,0]
"-123" [1,123,0]
"1.23E3" [0,123,1]
"1.23E+3" [0,123,1]
"12.3E+7" [0,123,6]
"12.0" [0,120,-1]
"12.3" [0,123,-1]
"0.00123" [0,123,-5]
"-1.23E-12" [1,123,-14]
"1234.5E-4" [0,12345,-5]
"-0" [1,0,0]
"-0.00" [1,0,0]
"0E+7" [0,0,0]
"-0E-7" [1,0,0]
"inf" [0,inf]
"+inFiniTy" [0,inf]
"-Infinity" [1,inf]
"NAN" [0,qNaN]
"SNaN" [0,sNaN]
"Fred" [0,qNaN]




------------
Elmer Rivera at 5/3/2002 10:26:46 PM


Ive got a column with a value of 9e+09, how do i convert it to 90000000.00 as varchar?