General information
Category:
Coding, syntax & commands
>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
And in one command line?
hmm, this should work:
SELECT f1,f2,fetc, padl( ltrim(str(np*100, 9)), 9 , '0') AS txtPrice ;
FROM tblSource ;
to file results.txt
Previous
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only