>>>This seems like it should be easy...
>>>
>>>COPY TO mytextfile.txt DELIMITED WITH |
>>>
>>>...but I still end up with comma's - how do I do this and get just the | used as a delimiter??
>>>
>>>Thanks!
>>
>>Have you tried:
>>
>>COPY TO mytextfile.txt DELIMITED WITH CHARACTER "|"
>
>This worked:
>COPY TO mytextfile.txt DELIMITED WITH CHARACTER |
>
>Thanks!

You're quite welcome -- though I only looked up info in the online help for the COPY TO command...