I created indexes with SET COLLATE TO 'GENERAL'. I set VFP session to SET COLLATE TO 'GENERAL'. But LIKE expression in WHERE clause is still case sensitive. That drives me crazy. I cannot replicate MS/SQL Server or ORACLE queries behaviour in VFP.
For my application that means if customer decides to move into C/S database I will have to change the views to replicate their behaviour. For example, last name search would be in VFP: WHERE LastName = ?parameter, but in SQL Server: WHERE LastName LIKE ?parameter+'%'.