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
The dialog boxes and menu commands you see might differ from those described in Help depending on your active settings or edition. To change your settings, choose Import and Export Settings on the Tools menu. For more information, see Visual Studio Settings.
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)