[DUG] SQL question

[Traci Sumpter]

Depends on the database, there are formating type functions like to_char ,
round, trunc etc...  

-----Original Message-----
From: delphi-bounces at ns3.123.co.nz [mailto:delphi-bounces at ns3.123.co.nz] On
Behalf Of Mark Howard
Sent: Friday, 24 June 2005 11:23 a.m.
To: delphi at ns3.123.co.nz
Subject: [DUG] SQL question

Can anyone suggest a way to return a figure of (say) 32.30 from a SQL SELECT
statement, instead of the 32.3?
I would like the returned number formatted as I'm just sending the dataset
straight out to a CSV file.

I'm using DBISAM but I'm willing to try ANY suggestions to see if they work.

TIA

Mark

--
Forest Production Systems Ltd
Creators of PSLog - A harvesting information system www.pslog.co.nz


-- 
No virus found in this outgoing message.
Checked by AVG Anti-Virus.
Version: 7.0.323 / Virus Database: 267.8.0/27 - Release Date: 23/06/2005

_______________________________________________
Delphi mailing list
Delphi at ns3.123.co.nz
http://ns3.123.co.nz/mailman/listinfo/delphi