Querying Full-Text Data
SQL Server provides two commands to query full-text data: CONTAINS and FREETEXT. There are two additional options that produce a result set with additional columns of information: CONTAINSTABLE and FREETEXTTABLE.
The main difference between the four commands is that CONTAINS and FREETEXT return a true/false value utilized to restrict a result set, whereas CONTAINSTABLE and FREETEXTTABLE return a result set that can be used to extend query functionality.
Like all SELECT examples within this book, I will be using the AdventureWorks sample database. You will need to create a full-text index on the Production.ProductDescription ...