>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