SQL SIMILAR (?): To combine IN and LIKE in Access 2007 VBA
Posted on 2009-07-14
I would like to combine the in and like predicates in Access 2007 into a SHORT string. If it helps, the wildcards will always be on the ends ([S Comment] should include any of the search words.
I tried ([S Comment] LIKE ("*Good*", "*Great*")) but Like won't work like In does (it spews on the commas).
([S Comment] IN ("*Good*", "*Great*")) won't work either: no results found, because IN isn't built to take wildcards.
Normally my list of search words is much longer.
The question: Would Similar work, and what would the syntax look like?