Use the minus '-' operator
"intermedia user" <s_komarovsky_at_yahoo.com> wrote in message
news:6088037f.0212101447.6295aa75_at_posting.google.com...
> Hi,
>
> I want to select all records from the table that has some word and its
> synonims in the subjects field.
>
> select distinct subj_term from org_subj_terms
> where contains(subj_term,'syn(fish)')>0
>
> The problem is I want to exclude records that also have other words.
>
> For example I want to select records with subject
> fish
> pets (synonym)
>
> but exclude
> records with fish equipment in the subject.
>
> How it can be done?
>
> thanks a lot.
Received on Wed Dec 11 2002 - 05:25:38 CST
