create-full-text-search-queries-visual-database-tools.md

title	Create Full-Text Search Queries
ms.custom	seo-lt-2019
ms.date	01/19/2017
ms.prod	sql
ms.prod_service	sql-tools
ms.technology	ssms
ms.topic	conceptual
helpviewer_keywords	CONTAINS predicate (Transact-SQL) queries [full-text search], creating full-text queries [SQL Server], creating
ms.assetid	537fa556-390e-4c88-9b8e-679848d94abc
author	markingmyname
ms.author	maghan
ms.manager	jroth
ms.reviewer

Create Full-Text Search Queries (Visual Database Tools)

[!INCLUDEappliesto-ss-asdb-asdw-pdw-md] 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 (SQL Server) and CONTAINS (Transact-SQL).

To 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.

See Also

Supported Query Types (Visual Database Tools)
Design Queries and Views How-to Topics (Visual Database Tools)
Perform Basic Operations with Queries (Visual Database Tools)