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?