Search across multiple columns (or instead of and)
Posted: Tue Jun 11, 2019 1:06 am
Hi,
I'm wondering if there is a way to search multiple columns simultaneously and receive items with any matching columns instead of only items where all columns match? So for example, if I want to search both Name & PartNo columns for the wildcard %25Bracket%25 and receive items where the word Bracket appears in either Name or PartNo?
I know this could be done with multiple queries, but if there is a way to achieve this in a single query I would love to know.
Thanks
I'm wondering if there is a way to search multiple columns simultaneously and receive items with any matching columns instead of only items where all columns match? So for example, if I want to search both Name & PartNo columns for the wildcard %25Bracket%25 and receive items where the word Bracket appears in either Name or PartNo?
I know this could be done with multiple queries, but if there is a way to achieve this in a single query I would love to know.
Thanks