case sensitive query

  • Thread starter Thread starter Randal
  • Start date Start date
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?
 
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"
 
Back
Top