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"
 

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
Oversensitive touchpad on modern laptops 0
Need a Case-Sensitive Group By Totals Query - Is there a Workaroun 4
Case Insensitivity 3
Case Sensitive Query 7
Basic query questions concerning a linked FoxPro table 5
Case Sensitivity 1

Back
Top