Slightly-OT: SQL Help

[Milan]

Hi,

We're just completing a disc done with Director/Valentina. Everything is
running great, but we've hit a stumbling block with SQL statements. Can
anyone explain how it is possible to achieve the following with Valentina:

1. User searches for: Mary

2. This gives results including: St Mary's, Mary Jane etc.

3. Search IGNORES a specific word, in this instance PRIMARY.

4. BUT.... St Mary's Primary would still be found.

How can this be achieved? The NOT LIKE command cannot be used, as we want to
include instances where MARY and PRIMARY exist together (RoseMARY, for
example). The word PRIMARY needs to be completely disregarded when the
search is performed.

Is this possible? If not, is there a workaround that anybody can suggest?

Regards,

bub.