>>>
>>>? INT(VAL(RTRIM(TRANSFORM(140400),"0")))
>>>
>>>>
>>Ok, the requirements are to remove trailing zeros. In other words, for
>>0015000 we need 0015, not 15.
>>
>>Thanks in advance.
>
>like this ?
>
>
>?padr(left('0015000', len(rtrim(strtran('0015000', '0', ' ')))), 15)
>
Ok.
If it's not broken, fix it until it is.
My Blog