Full Text Search Problems MSSQL
Posted on 2006-05-18
I'm having a problem where I have a full-text catalogue setup on a table "candidates" where the "CVText" field is the text that is indexed. Some our our clients have noticed that, when refering to a candidates name, no CV's are returned even thou the "CVText" field clearly contains it. The text is saved from our server via the Word Object and saved as Word HTML which sucks really as Word doesn't make a good job at all.
Would the HTML be causing a problem? Here is an example of "CVText":
<p class=MsoTitle><i style='mso-bidi-font-style:normal'><span style='font-size:
And part of the SQL statement is:
... INNER JOIN CONTAINSTABLE(candidates, *, '("ANDRE" AND "SANTANA")') AS K ...
The HTML, as bad as it is, does contain "ANDRE" AND "SANTANA" so why is it not being returned?