How to: Create Full-Text Search Queries
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 your database documentation.
Note
Your computer might show different names or locations for some of the Visual Studio user interface elements in the following instructions. The Visual Studio edition that you have and the settings that you use determine these elements. For more information, see Customizing Development Settings in Visual Studio.
To create a full-text search query
Open a query from Project 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)