Bruno Gomes
CCConvex Community
•Created by Bruno Gomes on 8/20/2024 in #support-community
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?1 replies