>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
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only