tobyinla:
The + trips me up because it’s a plus but it’s actually an “or”, sorta. lol.
No, it’s a plus. See Constructing a List with Subtraction here:
tobyinla:
Seems to me that INTERSECT is doing the heavy lifting in the statement, yes? It’s finding whether there is any “commonality” between my search form’s input and some columns in the table.
Correct.
tobyinla:
And I need to tell it to “don’t just look for exact matches, but partial matches are fine”. Hmmm.
That’s an entirely different requirement than you originally expressed. I’m not aware of a way to do partial matches with multiple terms from a single input without resorting to some ugly contrivances. It’s doable, but it’s ugly.