TRANSFORM(yourdata,'@L 9999999') && Be sure to include enough 9's
>Hello,
>
>How to zeros trailing in the front of each chararter field in the CSV file ?
>
>For example in mytable.dbf
>
>mytable.dbf
>
>myfield (char 5)
>
>00111
>01111
>
>when I used the copy to command :
>
>select mytable
>Copy to mytablecsv type csv
>
>always gave me in mytablecsv.csv for myfield
>
>111
>1111
>
>Tia