case sensitive query

R

Randal

I have a database linked to .dbf files using ODBC. These tables were
exported from VFP. Queries run against these tables are case sensitive by
default. Is there a way to change this so that I can run query that is not
case sensitive?
 
M

Mark

You could incorporate the StrConv function into your
query so that whatever case the input is entered as, it
will be converted before the query runs.

Expr1: StrConv("mark",1) = "MARK"
Expr1: StrConv("mark",2) = "mark"
Expr1: StrConv("mark",3) = "Mark"
 
Top