You could always use a string format in the output to CSV statement, and not have to worry about having the DB provide the correct format.
Jason -----Original Message----- From: Mark Howard [mailto:[EMAIL PROTECTED] Sent: Friday, 24 June 2005 11:45 a.m. To: [email protected] Subject: Re: [DUG] SQL question Traci I've tried round and trunc but they both drop any trailing "0"'s I'v also cast to Char but I can't find anything in the DBISAM documentation about casting to a defined format of Char ie $$$.$$ or F5.2 etc I want to avoid doing a complicated manipulation involving string lengths and substrings to build what I want - if there is another way. Thanks Mark On Fri, 24 Jun 2005 11:35:08 +1200, Traci Sumpter <[EMAIL PROTECTED]> wrote: > 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 > > -- 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
