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?0 Replies