Is there a way to do a "Contains" Query in Salesforce/SOQL that picks up that word in a sentence, but not if it's part of a word?

Example: I want to find NATO accounts that say NATO ___ so I can't use equals, but things like "Donato's" are appearing as well.

1 Answer

Try including the space in your LIKE clause, i.e.

SELECT Id FROM Account WHERE Name LIKE 'NATO %'