>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+'%'.
Why WHERE LastName LIKE ?parameter+'%' cannot be used in VFP? If you don't like to use UPPER(LastName) and corresponding tags, then provide that all names stored in upper case in database.
Edward Pikman
Independent Consultant