How to handle searching in an existing database where the state field has 2 versions of the text

I have an existing database that I need to search for states and it has two versions NY and ny.

Should I convert everything to uppercase and then search?
Was this page helpful?