More Query Help, Part II

[skalyanaraman]

I have asked the question, and got the answer , regarding how to run searches where we try to find,

FIELD1 like 'w/20 +(Bush,Garden) roll* coaster speed @0'

That is one from each set but the results within some characters.

But, the question is how to do a search such as,

FIELD1 like 'w/20 +(Bush,Gard*) roll* coaster speed @0'
where one(or more) of the terms in the first set and the second set is a wildcard word.
I know that wildcards and paranthesis do not work well for OR searches.

Am I being clear in explaining? sorry for the confusion. But the above example is what I want to do, but I know there are problems with it.

Thanks!!

[mark]

You could do it this way:
FIELD1 like 'w/20 +Bush roll* coaster speed @0' or
FIELD1 like 'w/20 +Gard* roll* coaster speed @0'