>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
Try SET COLLATE TO MACHINE.
hth,
George
Ubi caritas et amor, deus ibi est