How to search for an ASC code (upper case only) within a query

[K Roger]

I am trying to parse out data that was imported from an EXCEL file. (I still use MS OFFICE 2003). I have succeeded in parsing out the desired data into a single word field (in title case, all lower or all upper case and or a mix of them that I want to update to a separate field in the database. I can sort on this field in a query OK as well as doing a "Find" using the drop down window.



However, my problem is when I try running a query using the the "Contains" line, the selection e.g. "A" always fails. I have attempted various values, such as chr(65), asc(65) and 65 with an without quotes. I just cannot figure out the syntax to put in the "Contains" line, if indeed I can select a title case value. So far my only solution is to copy the value in a computed field (using Right, Left, Instr and Mid functions in several steps). This is a lot of work that involves about 6000 records.

Any help/suggestions would be appreciated.

KRoger

[RuralGuy]

Maybe this link will help: https://support.microsoft.com/en-us/kb/209674

[K Roger]

Thanks RuralGuy

At first blush and hopefully last blush the solution offered at your suggested link works!

Thank you very much!

[RuralGuy]

You are most welcome. Welcome to the site BTW.