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