Find doll but not dollar or dolly

[mediababy]

I am trying to do a find where I am searching through keywords in my db.

I want to find any record that has at least one of these keywords in them:

doll

barbie

marie osmond

but not these words

dollar

dolly

I cannot figure this out from my filemaker books.

Any tips on this would help *

Thank you for taking a look

Okay I understand now that I can use

=doll

& then do another find & constraining or extending the found set, but just wondering if there is a syntax that can be entered in one find field that will end up with the same final result set?

Edited November 27, 2006 by Guest

[The Shadow]

There is no way to do an generic "or" find using a single field, you must use multiple find requests.