>I have a number field which is padded with zero's. For example:
>
>0000012345
>000013456
>
>How can I programmatically remove the zero's??
>
>Many Thanks
? TRANSFORM(VAL('0000012345'))
? TRANSFORM(VAL('000013456'))
_______________________________________________________________
Testing displays the presence, not the absence of bugs.
If a software application has to be designed, it has to be designed correctly!
_______________________________________________________________
Vladimir Zografski
Systems Analyst