Basic and Advanced Queries


Once you’ve built and populated full-text indexes in your database, you can begin querying them to retrieve relevant data. This chapter is designed to provide an introduction to the features available through full-text search predicates and functions, and as a guide to the powerful search query grammar of SQL Server iFTS. SQL Server provides powerful full-text search querying capabilities, from the most basic phrase search to extremely complex searches involving Boolean operators, proximity searches, and weighted search terms. We begin our discussion of SQL Server iFTS with an introduction to the two available SQL Server search predicates, CONTAINS and FREETEXT.


Search Term Boolean Operator Search Token Search Application Search Phrase 
These keywords were added by machine and not by the authors. This process is experimental and the keywords may be updated as the learning algorithm improves.


Unable to display preview. Download preview PDF.

Unable to display preview. Download preview PDF.

Copyright information

© Michael Coles and Hilary Cotter 2009

Personalised recommendations