Hi Donald,

You can use IIF(,,):

SELECT IIF(UPPER(lr_accept)='F','Full', ;
       IIF(UPPER(lr_accept)='P','Partial', ;
       IIF(UPPER(lr_accept)='R','Rejected','OTHER'))) ;
        as accept , ;
   lr_number, ;
   lr_projid ;
FROM DD_Lar


>SELECT 'accept' = ;
>      CASE UPPER(lr_accept) ;
>         WHEN 'F' THEN 'Full' ;
>         WHEN 'P' THEN 'Partial' ;
>         WHEN 'R' THEN 'Rejected' ;
>         ELSE 'OTHER' ;
>      END, ;
>   lr_number, ;
>   lr_projid ;
>FROM DD_Lar

MartinJ

>
>
>This works just fine in my SQL Server 7 environment (different database, same table schema).
>
>Why does this NOT work in VFP8. What can I use that is similar?
>
>Fred Z.