Hi!
Number is stored just as a number. Any zeros are not shown and not stored. You can only display a value that way (with padded zeros), but not to store.
HTH.
>I have a table that has three fields and one is numeric. I want to copy the fields type sdf but I want to padl() the numeric field with one zero. I was hoping that I wouldn't have to add a character field and replace the numeric field over and then copy.
>
>tried:
>copy fields padl((str(chargecode)),9,"0"),... to file type sdf.
>
>Any ideas?
>Thanks,
>Eric
Vlad Grynchyshyn, Project Manager, MCP
vgryn@yahoo.comICQ #10709245
The professional level of programmer could be determined by level of stupidity of his/her bugs
It is not appropriate to say that question is "foolish". There could be only foolish answers. Everybody passed period of time when knows nothing about something.