A co-worker of mine is working on a database query to pull from a memo field. He wants it only to show tables with the word vi in it. The problem he is running into is it's giving him words like VIsit and inVIsible. How can he write the query to only return the exact value just VI.
Some of the VI words in the body contain quotes "VI" some are " VI" with spaces etc.
Any help would be appreciated, thanks!