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 ...

Get Microsoft® SQL Server® 2008 Step by Step now with O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.