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

[lollygagger]

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

 

[Jerry Whittle]

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'

 

[lollygagger]

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

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.

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

 

[John Vinson]

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 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]

 

[lollygagger]

Thanks for your response. I am using access and I did figure it out