SQL Amount Format
Posted on 2004-04-21
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.