Howto do a fulltext search ?

Hi,



I'm trying to do a fulltext search which returns the adjacent words also in the result, like u do a google search and it returns the paragraph containing the searched phrase.



Any tips ?

This should give you everything you need to know:

MSDN Full Text Search



1) Create a full-text catalog.

2) Create a full-text index on a table.

3) Wait for a few minutes while SQL Server indexes everything.

4) Query your database. (If you don't know how, then read this article on MSDN.)





The only thing you can't do is format your result to look like a Google blurb. Its not possible or even smart to do that in SQL, because that would couple your database layer and your presentation layer too tightly, which makes your application fragile and hard to scale. You should format the output of query in your application code, not in SQL.