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