>>I think I have not made myself understood.
>>
>>I am performing a COPY TO to an ASCII file. I prefer to delimit the ASCII file with a tilde (~). I need to have a tilde between ALL fields with NO OTHER DELIMITER in the file so I can BCP the data into SQL Server 6.5.
>>
>Try the following:
>
>COPY TO somefile.txt DELIMITED WITH CHARACTER ~ WITH (phantom space)
>
>Note.....When you get to the (phantom space) part type "255" on your number key pad while holding down the alt key to insert the "phantom space" character.
>
>Murray

Actually, upon further examination, that can get quite ugly if the chr(255) ends up in your data. You need to first remove it from the text file with chrtran. Oh well, maybe chr(255) isn't such a good idea since you could use any other char and use chrtran with it also.

Murray