I am developing application which might be running against VFP, SQL
Server, ORACLE, etc. database on customer choice.
I am trying to accomplish the same behavior for the queries(views). Thus, I use SET COLLATE TO "GENERAL" and SET ANSI ON for the local tables. The equal sign(=) in WHERE clause behalves the way all C/S databases do. But when I use LIKE expression, queries or views for VFP are still case sensitive in spite of "GENERAL" collation and using correct index for Rushmore optimization.
Is it another VFP bug or there is a workaround for it? I am trying to avoid using UPPER or LOWER indexes.

Please, HELP!
TIA
Dmitriy