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"
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

case sensitive join 12
IIF, but Case Sensitive 8
Inconsistent return 1
Case Sensitive Query 7
Case Insensitivity 3
Need a Case-Sensitive Group By Totals Query - Is there a Workaroun 4
Case Sensitivity 1
update query and case sensitive 2

Top