I wish to execute a SQL statement like below against a Foxpro Databse.
SELECT P_CRITICAL , (CASE WHEN P_CRITICAL = 'Quality' Then '+' Else '-' END) as P_CRITICAL FROM Foxpro.dbf
I'm unsure what version the Foxpro databases are at.
any help would be very much appreciated as I've tried many different combinations and I read that foxpro SQL is "different" to access SQL. I also tried the IIF got closer but no luck.
thanks in advance