Depends on the database, there are formating type functions like to_char , round, trunc etc...
-----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED] On Behalf Of Mark Howard Sent: Friday, 24 June 2005 11:23 a.m. To: [email protected] 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 [email protected] http://ns3.123.co.nz/mailman/listinfo/delphi _______________________________________________ Delphi mailing list [email protected] http://ns3.123.co.nz/mailman/listinfo/delphi
