[DUG] SQL question

[Mark Howard]

Alan
It is entirely certain that you are absolutely correct.  Excel does indeed ignore any trailing "0"s.
Thanks very much for raising that possibility - I can now pass the issue on to the client with a clear conscience.  A good way to end the week.
Thanks everyone for their input - especially to Alan for looking beyond the question and testing the reason for the question.
Mark
On Fri, 24 Jun 2005 13:14:07 +1200, Allan, Samuel <S.A.Allan at massey.ac.nz> wrote:

> It is entirely possible that Excel (don't quote me) might simply ignore
> the superfluous 0, even if it was there, and display it as 32.3, because
> that is how Excel displays real numbers by default? It may be that the
> only solution is to get your users to format their Excel spreadsheets
> after import.
>
> -----Original Message-----
> From: delphi-bounces at ns3.123.co.nz [mailto:delphi-bounces at ns3.123.co.nz]
> On Behalf Of Daryl Marsden
> Sent: Friday, June 24 2005 1:06 p.m.
> To: mhoward at pslog.co.nz; NZ Borland Developers Group - Delphi List
> Subject: RE: [DUG] SQL question
>
>
> Mark,
> 	I've read a few of the other suggestions and I have 2 general
> comments which may help.
> 1. rather than outputting to CSV "print" & format each line to the file
> 2. CSV=comma separated VALUES.  32.3 IS 32.30.  32.30 is how the value
> is displayed.  If you store irrelevant 0s then the resulting file will
> be bigger.  You could try fixed width field output (requiring even more
> space?)
>
> What is the file to be used for?  If input to spreadsheet or database
> then there should be problem.
>
> Daryl Marsden
> Project Management Analyst
> Environment Canterbury
> P O Box 345
> Christchurch
>
> Phone (03) 365-3828 Ext 7141
> Fax (03) 365-3194
>
> http://www.ecan.govt.nz
>
>
> -----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
> 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