>SELECT organization+" "+orgname FROM org INTO CURSOR cur2 NOCONSOLE
>or
>SELECT organization,orgname FROM org INTO CURSOR cur2 NOCONSOLE
>or
>whatever and still not be able to line up with the field width, it shows as now (using dots as space):
>
>01..Systems
>0101...Systems manager
>010102.Programmer
>010103.Designer
>02..Sales
>0201...Sales manager
>
>
>would like to show like this:
>
>01.........Systems
>0101.....Systems manager
>010102..Programmer
>010103..Designer
>02.........Sales
>0201.....Sales manager
>
>What can I do?
>
>Chuck

Say, your organisation field has 6 char length:

SELECT (PADR(organization, 6) + " " + orgname) AS orgID_orgname FROM org INTO CURSOR cur2