Thank you, Garret.
I forgot it.

MartinJ

>

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