Full Text Searching - MS Sql server

This article gives very valueable search scenario of MS Sql.
It is called full text searching. Normally this search is workl on the
base of words but not under character searching. Therefore this is
very rearly using and very usefully for contextual searching for
very large length of data columns.

This is most worthy article I have found when I need the full text search and at
that moment I was a dummy for full text searching at Ms Sql database server.

The reference url is below :-

http://blog.sqlauthority.com/2008/09/05/sql-server-creating-full-text-catalog-and-index/#comment-330663