How to perform a select considering that there may not be an exact comparison in the database. I know there is LIKE
, but I've already tried and did not have the desired effect.
The problem is next, I have to search the bank for a name that may be missing a letter at the end or at the beginning, for example, the bank may be so JOSIVAN SOUSA but the search entry may be:
- JOSIVAN SOUS
- JOSIVAN DE SOUSA
- OSIVAN SOUSA
And so on.