Doug,

>Is there a way to embed a CASE expression in a SELECT statement in VFP? I can >do it in SQL passthru using SQL Server 7, but can't get it to work in VFP and >can't find any documentation that it is even allowed?

Case is not valid in VFP. Use IIF() and in() and inlist() instead to achieve desired results.

Cheers
Steve Lea