Hi,

Here is the query I am using for my full-text searching:

SELECT COUNT(*) as hits
FROM links a, links_details b INNER JOIN
CONTAINSTABLE (links_details, *, @strSearch, 200 ) c
ON b.link_id = c.[KEY]
WHERE (a.link_id=b.link_id) AND (c.rank>70)
OPTION (KEEPFIXED PLAN)


If @strSearch = "small business" the query returns all the results in the table that match.

However, if @strSearch = "small business opportunities" the query returns no results even though there are records in the full-text indexed column that contain this exact phrase, in that exact order.

Is there anything I can or need to do to the query to make it work properly?

TIA,
Mike