>>I am trying to produce a delimited text file
>>
>>COPY TO d:\eudora\attachb\testa.csv DELIMITED WITH "~"
>>
>>But that puts the ~ before and after every field so my file looks like
>>
>>~Colin New York Inc~ ~14th Floor~ ~World Trade Center~ ~New York~ ~NY10001~ ~Colin Northway~ ~0016468424105~ ~~ ~colin@colin-northway.com~ ~COL999~ ~816227~ ~~
>>
>>
>>What is the correct instruction?
>
>sorry slight brainstorm now am using copy to d:\eudora\attachb\testa.csv Type Delimited With Character ~ BUT
>
>"Colin New York Inc"~"14th Floor"~"World Trade Center"~ I don't want the quotes how do I get rid of them?

Try

COPY TO test.txt DELIMITED WITH "" WITH CHARACTER ~