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


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.