Way to query both ProperCase & Upper Case

[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.

 

[Ken Snell \(MVP\)]

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".

 

[Guest]

My database may not be true Jet-----I think it was converted about a year
ago. I can tell my queries are case sensitive.

 

[Ken Snell \(MVP\)]

Post an example of one of your queries' SQL statements.

 

[Rick Brandt]

My database may not be true Jet-----I think it was converted about a
year ago. I can tell my queries are case sensitive.

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.