>>>This is one of the few cases where you don't use "delimiters to delimit the delimiter"
>>>Copy To .. DELIMITED with ,
>>>>After all these years I still forget: how to create a comma delimited file from a table. I just want the fields seperated with commas, no quotes. COPY TO ... DELIMITED WITH ???
>>
>>No, this gives me 3 commas for each field (before, after and a comma between)
>
>Sorry, I'm getting old...!
>COPY TO ... DELIMITED WITH "" WITH CHARACTER ','
That was the one I was looking for. Thanks.
In the End, we will remember not the words of our enemies, but the silence of our friends - Martin Luther King, Jr.