Shane:

The TYPE keyword is optional.

>>John:
>>Now for part two. Once I create this table, I do some work on it and overwrite the text file with a COPY TO name DELIMITED WITH TAB (after making a backup of course). The help says I can stack WITH commands (i.e.; DELIMITED WITH BLANK WITH TAB) but it doesn't work. I need the resulting file to be tab delimited with no string delimiters (quotes around each field). Can you help with this?
>>
>>>I would generally agree, Cetin. But, sometimes, you have to use things you don't like :-)
>>>>>>>THANKS!
>>>>>>>Tom.
>
>It should be COPY TO name TYPE DELIMITED WITH TAB
>
>You skipped TYPE
>
>Shane