Case in VisualFoxpro query.

Aug 6 2019 12:58 AM

Hi I hope you can help.

I wish to run an SQL case statment against a FOxpro Dabase.

I'm using ODBC Microsoft Visual Foxpro Driver and getting errors using case statment
against a Foxpro DB, it works fine against a sql Databse. From reading i believe
the foxpro's SQL is "different" than that of SQL.

So could someone tell how to use case in foxpro sql statement.
Thanks in advance