"tank047" wrote:

> I am trying to create a full text search that uses a web interface similar to
> google's advanced search, which allows users to choose such things as "with
> this exact phrase" , "with all of these words" , "Without these words" etc.
> When i use the "containstable" keywords it seaches each column and ensures
> that each column meets the specified criteria. This is not what I am looking
> for. I am looking for the query to search each record for the criteria,
> meaning that in the example below "Head of Department" and "Economics" do not
> have to exist in the same column, but rather just the same record. I tried
> using freetexttable but this was too lose and it did not exclude words that
> contained the exlusionary criteria. I would really appreciate any help on
> this. I thought of concatenating all information into one column and
> indexing that column but it did not seem to be the best solution. I am sure
> i must be missing some simple syntax.
>
> Thank you in Advance
>
> tank047
>
> SELECT * From tblcontacts INNER JOIN (SELECT DISTINCT TOP 100 c.id AS
> contact_id, k.rank FROM contacts as c INNER JOIN freetextTABLE (tblcontacts,
> *, '"Head of Department" AND (Department AND Economics) AND NOT
> (university)') AS k ON ID = k.[key] ORDER BY k.rank DESC ) AS rankedIDs ON
> contacts.id = rankedIDs.contact_id