Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations TouchToneTommy on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Keeps displaying Scientific Notation

Status
Not open for further replies.

Gatorajc

MIS
Mar 1, 2002
423
US
How do I stop a number from being converted to scientific notation when coming out of a database? It is not in scientific notation in the database. But for some reason it displays like this 1.23456789123456E+15, when it is 15 digits it is fine just when its 16 digits does the problem develop. I have not tired convert or cast yet in my sql statement because of the way the query string is passed in the () mess it all up. Im trying to find another way before resorting to that. Is there another way to cast using ASP, html, or even something else.
 
Try FORMATNUMBER(variable,number of decimal places >= 0)
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top