>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])
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
