thanks guys, both solutions work just fine, as always the U.T. comes through again, I appreciate the support.

Jim


>What about something like this.
>COPY TO saleco DELIMITED WITH "" WITH CHARACTER ""
>
>Bob Lee
>
>
>>Hi All,
>>
>>How is it possible to copy a file with one field (character 6), to a text file to be opened in "Word" that has the exact same info, no spaces, no quotes (single or double)?
>>
>>creates text file with a blank character in front
>>COPY TO saleco DELIMITED WITH ' ' && one space between single quotes
>>
>>creates a text file with single quotes in front and back
>>COPY TO saleco DELIMITED WITH '' && no space()
>>
>>creates a text file with double quotes in front and back
>>COPY TO saleco DELIMITED WITH blank
>>
>>Jim Harvey