>>>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
>>
>>Have a look at the STRTRAN command:
>>
>>
>>STRTRAN("000013456", "0", "")
>>
>>
>>Kev
>
>Huh? STRTRAN("0000134000056", "0", "") would give '123456' where you for sure would want '1234000056'. So, this solution is not worth the three stars. You better simply do something like
>
>LTRIM(STR(VAL("000013456")))
Good point.