O'Reilly logo

Microsoft® SQL Server® 2008 Step by Step by Mike Hotek

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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.

Note

Note

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

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required