-
Convert & Cast Function
Ive got a column with a value of 9e+09, how do i convert it to 90000000.00 as varchar?
-
Convert & Cast Function (reply)
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?
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|