Re: Criterias with Full text search

Hello Pascal,

You have to use containstable for that


Simon Sabin
SQL Server MVP
http://sqlblogcasts.com/blogs/simons


I am trying to create a full text search which allows users to choose
such things as "with this exact phrase" , "with all of these words"
AND "Without these words" etc.

I tried using freetexttable command to search through the columns
which was fine but it did not exclude the words that was contained in
the DO NOT criteria. It seems to be searching for all the text that
is contained in the columns but it is avoiding to validate the DO NOT
criteria?

Help would be appreciated on this one cause I can't get it going.

Thank you in Advance

LeeRoy

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


.

Loading