>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

i don't know but can you use ICASE(), just as you can use IIF(), in SQL?

UPDAE: Oh, I see now that that's been covered