>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.
Yes, replace the zeroes with spaces, apply alltrim(), and then replace the spaces with zeroes (to account for zeroes in between). This can be done in a single expression.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)