Solved

SQL Amount Format

Posted on 2004-04-21
3
898 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

VMware Disaster Recovery and Data Protection

In this expert guide, you’ll learn about the components of a Modern Data Center. You will use cases for the value-added capabilities of Veeam®, including combining backup and replication for VMware disaster recovery and using replication for data center migration.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Nowadays, some of developer are too much worried about data. Who is using data, who is updating it etc. etc. Because, data is more costlier in term of money and information. So security of data is focusing concern in days. Lets' understand the Au…
International Data Corporation (IDC) prognosticates that before the current the year gets over disbursing on IT framework products to be sent in cloud environs will be $37.1B.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.
Viewers will learn how to use the UPDATE and DELETE statements to change or remove existing data from their tables. Make a table: Update a specific column given a specific row using the UPDATE statement: Remove a set of values using the DELETE s…

808 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