I have write a program with ADO

The program must run with VFP databases and SQL database

If i use a sql statement in sql server it is not case sentive

lSql = "SELECT * FROM RELA WHERE pers like 'DO%' or place like "AMS%'"
Recordset.open(lSql,connection,1,2)

IF i have an index on pers and place the query is very fast

Now the problem

IF i use the VFP databases
The index on pers and place are like UPPER(pers) and UPPER(place)

If i use the statement before it wil not work.

if have to use the statement

lSql = "SELECT * FROM RELA WHERE {fn UCASE(pers)}like 'DO%' or {fn UCASE(PLACE)} like "AMS%'"
Recordset.open(lSql,connection,1,2)

How can solve this

Kind regards


Jan Dorresteijn