>>Ignore the example below. I spaced it out nice but the SPACES were removed when posted.
>>
>>>I am DEFINEing a POPUP based on STR(Projnum,3)+" "+Projdesc. The Projnum's are not right-justified together making the list look sloppy.
>>>
>>>ie. 3 Desc1 should look like 3 Desc1
>>> 13 Desc2 13 Desc2
>>> 123 Desc3 123 Desc3
>>>
>>>How do I correct this?
>
>When ever you convert a numeric to a character by using STR() you should ALLTRIM() the results. Otherwise you will get spaces in your result.
>
>-Ed
Ed,
I want the leading spaces in the result because all three numbers should line up right-justified.
Colin Magee
Team Leader, Systems Development
Metroland Media Group Ltd.
Mississauga, Ontario, Canada
cmagee@metroland.comNever mistake having a career with having a life.