>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
Try:
? TRANSFORM(VAL(CHRTRAN("ABCD0000110231",CHRTRAN("ABCD0000110231","0123456789",""),""))) -> 110231
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.