>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?
>
>Thanks,
>Doug

Doug, you can call the UDF within your SELECT and your UDF will have that CASE statement and return the value according the CASE.
From your UDF you can even call another SELECT to get some values.

Nick