Paul,
I guess you use 'Copy to yurscsv type csv'? If so, you nedd to temporarily add an extra character field for each field you need with the preceding zeroes. This may mean you have to copy the data to an intermediate cursor. Then you use the transform function to populate the extra character fields with the values you want, including the zeroes. The thing is, you must use character fields for this to work.
>Tore,
>
>Yes, I can transfrom data but when copying to CSV file, zeros always disappeared again. I believe CSV file never kept zeros in front of
>123456789 even the field is character or numeric.
>
>****TRANSFORM(yourdata,'@L 9999999') && Be sure to include enough 9's
>
>Any other ideas how to do this really appreciated .
>
>rgds,