You can use ICASE() or IIF(), but not the CASE or IF statements
>Can you use a CASE statement in a VFP query (similar to SQL Server)? If not, what is the best way to populate a field if it is empty when running a query? I want it to have something like 'View Record' if the field is empty or the field value if there is something in the field. Hopefully this makes sense. Thanks.
>
>Doug
Craig Berntson
MCSD, Microsoft .Net MVP, Grape City Community Influencer