• Some links for understanding and reference:

    Hilary Cotter's article: http://www.simple-talk.com/sql/learn-sql-server/sql-server-full-text-search-language-features/

    Full-Text Search Q and A http://msdn.microsoft.com/en-us/sqlserver/aa336328.aspx which contains the answer to the Question: why do we need full text if we can use "like" in select query?

    Microsoft Technical Article SQL Server 2005 Full-Text Search: Internals and Enhancements

    http://msdn.microsoft.com/en-us/library/ms345119(SQL.90).aspx which contains an answer (http://msdn.microsoft.com/en-us/library/ms345119(SQL.90).aspx#yukonftsea_topic2) to the question:

    What Can Full-Text Search Do for Me?


    [font="Arial Narrow"](PHB) I think we should build an SQL database. (Dilbert) What color do you want that database? (PHB) I think mauve has the most RAM.[/font]