Create Full-Text Search queries (Visual Database Tools)

Applies to: SQL Server

Full-text searches use the CONTAINS predicate to locate rows that have specified text in a given column. Full-Text searches are only possible on columns that have active full-text indexes. If you attempt to use the CONTAINS clause on a column that doesn't have a currently active full-text index, you receive an error. For more information on full-text indexes and the CONTAINS clause, see Full-Text Search and CONTAINS.

Create a full-text search query

1. Open a query from Solution Explorer or create a new one.

2. In the WHERE clause of your query, use the CONTAINS function to search a full-text column.

Related content

• Supported Query Types (Visual Database Tools)
• Design queries and views how-to articles (Visual Database Tools)
• Perform Basic Operations with Queries (Visual Database Tools)