>>>>>you may try alltrim(padr(myNumber,16))
>>>>
>>>>Nope,
>>>>This doesn't remove the trailing zeros.
>>>
>>>You're right, I should have tried first. Sorry about it.
>>
>>I often post my examlpes as I thougth they should work.
>>Once I wrote something like "I asssume that ....". Marcia Akins answers that assume means: Make "A$$ U & ME" [LOL]
>>She is right of course.
>
>In this particular case it's a bit funny. I recalled I asked a question here (from another forum) and got an answer by SB about RTRIM (no, I didn't recall all the details, as I recalled them now). I then confused PADR & RTRIM and hurried to post a solution <g> That only proves the expression used by my former match teacher: "You should hurry only when catching fleas" <g>
ROFL
I totaly agree with your teacher.
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.