Win a copy of Re-engineering Legacy Software this week in the Refactoring forum
or Docker in Action in the Cloud/Virtualization forum!
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

SQL Server - convert large number to string problem

 
Ronan Dowd
Ranch Hand
Posts: 84
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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.
 
Scott Selikoff
author
Saloon Keeper
Posts: 4008
18
Eclipse IDE Flex Google Web Toolkit
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
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?
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic