How to: Create Full-Text Search Queries (Visual Database Tools)
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 does not have a currently active full-text index, you will receive an error. For more information on full-text indexes and the CONTAINS clause, see Full-Text Search Concepts and CONTAINS (Transact-SQL).
To create a full-text search query
Open a query from Solution Explorer or create a new one.
In the WHERE clause of your query, use the CONTAINS function to search a full-text column.
See Also
Concepts
Supported Query Types (Visual Database Tools)
Other Resources
Designing Queries and Views (Visual Database Tools)
Performing Basic Operations with Queries (Visual Database Tools)
Working with Indexes (Visual Database Tools)