Querying SQL Server Using Full-Text Search

This section describes the different types of searches you can perform using full-text search.

Querying varbinary(max) and xml Columns

Searching for Specific Word or Phrase (Simple Term)

Querying Multiple Columns

Performing Prefix Searches

Querying Linked Servers

Searching for the Inflectional Form of a Specific Word (Generation Term)

Integrating Full-Text Search and Transact-SQL Predicates

Searching for Words or Phrases Using Weighted Values (Weighted Term)

Comparing Full-Text Functions and Full-Text Predicates

Searching for Words or Phrases Close to Another Word or Phrase (Proximity Term)

See Also

Other Resources

Full-Text Search Concepts

Help and Information

Getting SQL Server 2005 Assistance