That's very odd...
You'll probably have to scan through the records and create the file yourself, rather than depending on "COPY TO" to make the file. You can use transform() to format that field appropriately.
>I need to zero fill the number and not have the quotes there as the file must be in this format so that it can be imported into a Mapper system. The system requires the numeric fields to be zero filled.
>
>Is there perhaps some work around?
Steve Gibson