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?
>