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