This seems like a doable option.

Thanks.

>>I need to copy a dbf to a text file. COPY TO ...TYPE SDF works great except for one little problem, it does not zero fill numeric fields. I am creating a file for use on our main frame and it needs zero filled numerics.
>>
>>Does anybody know of an easy solution to this problem?
>
>You might try converting the numeric fields to character before the COPY TO (or through an SQL-SELECT)
>
>>
>>Thanks.