Page 1 of 1

More Query Help, Part II

Posted: Thu May 09, 2002 8:55 pm
by 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!!

More Query Help, Part II

Posted: Fri May 10, 2002 11:15 am
by 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'