| Author |
SQL Server - convert large number to string problem
|
Ronan Dowd
Ranch Hand
Joined: Jan 21, 2006
Posts: 84
|
|
Hi All,
Am using oracle sqlserver express 2005. One of my table columns contains the numeric value 1878388.
When i try convert this value to a string (in my SQL statement) using the below function i get the result of "1.87839e+006"
CONVERT(VARCHAR(30), ROUND(TSGCustomer.income/1024,3) )
"1.87839e+006" is the scientific notation, I would it to return the non scientific value of 1878388, but as a string/varchar
Any help/advice would be great.
Thanks, Ronan.
|
SCJP 1.4 | OCWCD JEE 5
|
 |
Scott Selikoff
Saloon Keeper
Joined: Oct 23, 2005
Posts: 3652
|
|
|
If this is a JDBC application, you can return it as a number and read it using getLong(). Otherwise, have you tried the to_char() function?
|
My Blog: Down Home Country Coding with Scott Selikoff
|
|
 |
|
|
subject: SQL Server - convert large number to string problem
|
|
|
0
