>SELECT IIF(UPPER(lr_accept)='F','Full ', ; > IIF(UPPER(lr_accept)='P','Partial ', ; > IIF(UPPER(lr_accept)='R','Rejected','OTHER '))) ;You should pad the field with spaces, because the SELECT statement will figure the width of the column from the first record it finds.