More Query Help, Part II

Post Reply
skalyanaraman
Posts: 109
Joined: Tue May 29, 2001 9:13 pm

More Query Help, Part II

Post 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!!
User avatar
mark
Site Admin
Posts: 5519
Joined: Tue Apr 25, 2000 6:56 pm

More Query Help, Part II

Post 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'
Post Reply