Hi
I have a problem displaying data in the correct format.

I have tried the Cast() command and also different data types - e.g decimal
9,2; numeric 9,2 with no success. I can easily display the correct format
in a Delphi grid but not in a web page. Can anyone help, please?

Data stored in the database table is as follows:
Supplier Tonnes Value
A1 12.12 13.55
A2 12.1 13.5
A3 12 13

I want to display 2 decimal places:-
Supplier Tonnes Value
A1 12.12 13.55
A2 12.10 13.50
A3 12.00 13.00
Alternatively, how can I force the stored data to respect the precision and
scale settings?
Thanks
Alan


Alan J Davies
Aldis
Tel: +44(0)1926 842069
Fax: +44(0)1926 843755


--
Outgoing mail is certified Virus Free.
Checked by AVG Anti-Virus (http://www.grisoft.com).
Version: 7.0.245 / Virus Database: 262.10.4 - Release Date: 22/05/2004