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

query to show where no data in a stated column 0
IIF, but Case Sensitive 8
Need a Case-Sensitive Group By Totals Query - Is there a Workaroun 5
Case Insensitivity 3
Trying to create a report that will list unmatched records by Ticket Primary Key 0
case sensitive join 5
how do I deal with case sensitive data in Access? 2
Case Sensitive Query 7

Top