Solved

SQL Amount Format

Posted on 2004-04-21
3
894 Views
Last Modified: 2008-02-26
Hi,
My Project Backend is MS.SQL 7.0.
In a table there is one field amt_amount, type is Float, Lentgh is 8 and  Prec is 53.

Now the problem is, in case of large value it is not coming in a proper format, it is showing like  "1.3854593718367629E+18". I need to show it in proper format, how to solve this problem.
The of table creation is
"Create Table T_STK amt_amount float (53)"

Please, help me to solve this problem.

Thanks & Regards,
Anirban Das Gupta.

0
Comment
Question by:anirban_abn
3 Comments
 

Author Comment

by:anirban_abn
ID: 10876346
SQL Amount Format
0
 
LVL 26

Expert Comment

by:Hilaire
ID: 10876414
could you post an exemple of what would be a proper format ?

0
 
LVL 34

Accepted Solution

by:
arbert earned 30 total points
ID: 10878898
This isn't a storage issue--this is usually something you accomplish on your frontend/client using built in format routines....
0

Featured Post

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Join & Write a Comment

I wrote this interesting script that really help me find jobs or procedures when working in a huge environment. I could I have written it as a Procedure but then I would have to have it on each machine or have a link to a server-related search that …
Ever wondered why sometimes your SQL Server is slow or unresponsive with connections spiking up but by the time you go in, all is well? The following article will show you how to install and configure a SQL job that will send you email alerts includ…
Using examples as well as descriptions, and references to Books Online, show the documentation available for date manipulation functions and by using a select few of these functions, show how date based data can be manipulated with these functions.
Via a live example, show how to backup a database, simulate a failure backup the tail of the database transaction log and perform the restore.

747 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now