Hello all,
I want to build a Freetext query in sql server 2005 which returns some portion of the text around the matching criteria (word/phrase). That is, if i search for say, "valuable asset", the result should be something like "....positive attitude is the most valuable asset of a person, which....".
The column contains files of MS office 2007 (docx, pptx, xlsx,etc), html, txt and pdf formats.
Any suggestions?