Case sensitive in criteria?

[mcarter]

In one database, I can type "ny" in the criteria for "state abbv" field and
the query with return all records with "NY" in the field. I can't do this in
a different databse that I made. WHY?!
for example in the new database, i have field LOB that contain WC or EO. When
I enter "eo" in the criteria, no records are found. If I enter "EO"in the
criteria, records are found.

 

[John W. Vinson]

In one database, I can type "ny" in the criteria for "state abbv" field and
the query with return all records with "NY" in the field. I can't do this in
a different databse that I made. WHY?!
for example in the new database, i have field LOB that contain WC or EO. When
I enter "eo" in the criteria, no records are found. If I enter "EO"in the
criteria, records are found.

Access itself isn't case sensitive, but some other database engines are. Is
this a linked table from (say) Oracle, MySQL, or SQL/Server?

 

[mcarter]

THANK YOU!!! Yes! all my tables are linked to Oracle in the database
that "seems" case sensitive. I want the criteria to be a parameter input
so the user can input either eo or wc. I've got [Enter LOB (EO or WC)], but
am trying to program to account for the lazy user who doesn't use caps.
I tried UPPER, but couldn't get it to work. Thanks Again!

 

[John Spencer]

Try UCase

WHERE SomeField = UCase([What do you want now?])

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
Center for Health Program Development and Management
University of Maryland Baltimore County
'====================================================

THANK YOU!!! Yes! all my tables are linked to Oracle in the database
that "seems" case sensitive. I want the criteria to be a parameter input
so the user can input either eo or wc. I've got [Enter LOB (EO or WC)], but
am trying to program to account for the lazy user who doesn't use caps.
I tried UPPER, but couldn't get it to work. Thanks Again!

Access itself isn't case sensitive, but some other database engines are. Is
this a linked table from (say) Oracle, MySQL, or SQL/Server?