How can I cancel case-sensitive in database fields when searching

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

When doing a query on data base files, I would like to be able to turn off
case sensitive. How can I do that?
 
Access isn't case sensitive. What brand of database are you linking to?

If Oracle, you can't turn it off. Instead you need to use the Upper function
to make everything upper case. Of course this messes up using a conventional
index.

WHERE Upper([TheField]) = Upper([YourParameter])

You could use something convoluted like below:

WHERE [TheField] = 'SMITH'
OR [TheField] = 'Smith'
OR [TheField] = 'smith'
 
I'm very new to Access. I was asking about Access Data base and you answered
my question by letting me know it is not case-sensitive. Thanks

Jerry Whittle said:
Access isn't case sensitive. What brand of database are you linking to?

If Oracle, you can't turn it off. Instead you need to use the Upper function
to make everything upper case. Of course this messes up using a conventional
index.

WHERE Upper([TheField]) = Upper([YourParameter])

You could use something convoluted like below:

WHERE [TheField] = 'SMITH'
OR [TheField] = 'Smith'
OR [TheField] = 'smith'
--
Jerry Whittle
Light. Strong. Cheap. Pick two. Keith Bontrager - Bicycle Builder.


lollygagger said:
When doing a query on data base files, I would like to be able to turn off
case sensitive. How can I do that?
Click to expand...
Click to expand...
 
When doing a query on data base files, I would like to be able to turn off
case sensitive. How can I do that?
Click to expand...

Access is ALREADY non-case-sensitive, and it's durned difficult to
MAKE it case sensitive.

Are you using Access, or some other DBMS to store your data?

John W. Vinson[MVP]
 
Back
Top