Thank you!
>
SELECT invno, IIF(usesr2,salesrep2, SPACE(LEN(salesrep2))) FROM invpost
>* or
>SELECT invno, PADR(IIF(usesr2,salesrep2,''), LEN(salesrep2)) FROM invpost
>
>
>>SELECT invno, IIF(usesr2,salesrep2,'') FROM invpost
>>
>>The above select returns only the first character of the salesrep2 field. I think that is because the usesr2 is a Logical field. How can I return the full length of the salesrep2 field?
>>