VFP8 does support SQL language native to backend for remote views in the View Designer. In case of SQL Server, you can use CASE function or any other valid T-SQL functions and operators in the view query.

>I wonder if the next version of VFP could support MS Transact SQL: select case....end
>structure in remote view designer?
>
>B.Rgds