Re: comma delimited

From: Shredder <shred_at_shredder.com>
Date: Thu, 27 Jul 2006 15:40:13 GMT
Message-ID: <x75yg.36328$vl5.22521@tornado.ohiordc.rr.com>

"Shredder" <shred_at_shredder.com> wrote in message news:BFvxg.36145$vl5.31156_at_tornado.ohiordc.rr.com...
>I am forced to use a somewhat generic sql editor that does not allow me to
>save my output to a comma delimited file (CSV). Is there a way to include
>something, in my script, to generate this output with the commas in it?
>

Finally got it to work ... used ....

select ' '||field1||',',' ' ||field2||',' from table where field1 = 'mydata';

Thanks to all! Received on Thu Jul 27 2006 - 10:40:13 CDT