Hi Dan

That's what I should have done. Say it in English and people won't try to run the code. ;)

>>This looks like we're working on a txt file rather than a dbf. So I ran your line but there was no difference in the resultant file. The thing is the location field is 15 spaces long but any trailing spaces get wiped out in the {COPY TO e:\output.txt DELIMITED WITH "" }statement. I actually need those spaces( as I may have already stated) :-(
>>
>>
>>>>>>That was the one I didn't try, I was almost out of choices!
>>>>>>PS, what if I wanted output to look like:
>>>>>>811AD,SUDBURY++++++++,B021193
>>>>>>note the '+' being spaces.
>
>Can you issue a select prior to the copy to which pads out your character fields with '+'.