>>Hi everybody,
>>
>>If we have these numbers
>>123000
>>130000
>>140400
>>
>>and we need 123, 13, 1404 (e.g. remove the trailing zeros), can we do it without loop? I don't see a way after thinking 3 minutes on the problem.
>>
>>Thanks in advance.
>
>?CHRTRAN(ALLTRIM(CHRTRAN(TRANSFORM(myNumber),[0],[ ])),[ ],[0])
>
Sergey's solution seems to be the easiest one, as always <g>
If it's not broken, fix it until it is.
My Blog