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