>I used COPY TO file.TXT type SDF
>
>All is OK but only problem in price field (numeric)
>
>it was exported as: 88.00
>
>They want it without "." and completed with zeros as the the size of the DBF field
>
>It should be exported as 000008800
>
>Thanks
>
>Moises
SELECT ......, PADL(INT(TRANSFORM(Price*100)), 9, [0]) AS Price;
FROM ...
INTO CURSOR crsCopy
SELECT crsCopy
COPY TO file.TXT SDF
USE IN crsCopy
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
