I have fixed set of Account Names stored in one custom object.
Set<String> NameSet = new Set<String>();
Custom object NameSet account Name values: Intel, HP, Dell, IBM etc
I have a query on Account object. My Account Names are Intel-Aus, HP, Dell-US, IBM etc
List<Account> accList = [Select Name from Account where Name IN: NameSet]
The above accList only gives 2 records HP and IBM!
Intel and Dell do not come in the list because these account names have "hyphen" in it.
How do I write the query to get all the Account Names using %Like% in a single query.