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