Way to query both ProperCase & Upper Case

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

Guest

Any way to query both propercase and Upper case without having to manually
write out both forms?

How can I find both TOM and Tom---I have a long list of similar criteria, I
wonder if there is a simple way to do it.
 
ACCESS Jet does not differentiate between upper and lower case letters when
searching. Searching for "tOm" will return "TOM", "tom", "tOm", "TOm",
"tOM", "TOm", "toM", and "toM".
 
My database may not be true Jet-----I think it was converted about a year
ago. I can tell my queries are case sensitive.
 
MFR said:
My database may not be true Jet-----I think it was converted about a
year ago. I can tell my queries are case sensitive.
Click to expand...

Are the tbales actually links? They would have a black arrow next to the
icon or they would have a globe for an icon if they are ODBC links. If they
are ODBC links then you could be usin a back end that is case sensitive.

In that case you have to use a fairly inefiicient criteria.

SELECT *
FROM TableName
WHERE UCase([FieldName]) = UCase(YourCriteria)

If you can control the case of the criteria string and make it all upper
case to begin with then the second UCase() function would not be required.
 
Back
Top