Why not place a one character field between each actual field with modify structure, alter table or as part of an SQL SELECT. Populate the one character fields with a single tab character then just COPY TO ... SDF.
Good Luck

>I have a table with numeric, integer, character, and date fields and it's mandatory to create an export file of type tab delimited.
>
>Using the COPY TO filename DELIMITED WITH TAB is fine and dandy, except for the fact that all character type fields get exported with doble quotes(") at the beginning and end of each value. The accounting package that needs to import these values will not understand them correctly since it takes no "
>
>Now, I tried every possible combination of syntax values and everything else until the only way I could get it to work was with some spaghetti code that my buddy and I wrote for it.
>
>I tell you...
>
>
>
>
>Any ideas? TIA