>>
>>? 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.
Can you tell me how you have a number with leading Zeroes? :-)
You this is a string?
Just don't convert it to number.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.