No idea what's causing it to fail. I've also tried it was a comma separating the values and get the exact same results ... no results.
Wondering if it's failing because it's not picking up the individual words and it's trying to match records to the entire value... in this case the value is "Seascapes Elvis ZZ Top" and it returns nothing.
If I only have Seascapes it returns Seascapes.
I would think even with the value of "Seascapes Elvis ZZ Top" it would return any record that has any of those words in it.. unless I'm misunderstanding how LIKE works. Or do I have to add something else to make this work?