Windows SharePoint Services Search SQL Syntax

This content is outdated and is no longer being maintained. It is provided as a courtesy for individuals who are still using these technologies. This page may contain URLs that were valid when originally published, but now link to sites or pages that no longer exist.

Search in Windows SharePoint Services provides support for constructing complex search queries through the SQL syntax. Some examples of what is available when using SQL syntax for search queries include the following:

• Comparison operators, such as ">", "<", or "=". For more information, see Literal Value Comparison.

• Multiple logical operators, such as AND, OR, and NOT. For more information, see WHERE Clause.

• Wildcard searches. For more information, see Using Wildcards in the CONTAINS Predicate.

Note

For basic search queries, use the Keyword Syntax reference instead.

The topics in this section describe the SQL syntax used for Search in Windows SharePoint Services.

In This Section

Query Language Information

Overview of the SQL Search Query

SELECT Statement

FROM Clause

WHERE Clause

ORDER BY Clause

SET Statement

Related Sections

Building Windows SharePoint Services Search Queries

Windows SharePoint Services Search Keyword Syntax

Windows SharePoint Services Search URL Syntax

See Also

Reference

Microsoft.SharePoint.Search.Query.FullTextSqlQuery

Concepts

Windows SharePoint Services Search Query Object Model

Windows SharePoint Services Query Web Service