SharePoint Search SQL Syntax Reference

Applies to: SharePoint Server 2010

Tip

The Keyword syntax enhancements in SharePoint Server search provide support for functionality that was previously available only by using SQL syntax, such as comparison, logical, and wildcard operators. If the Keyword syntax meets the requirements for the queries you need to construct for your custom search application, we recommend that you use it instead of the SQL syntax. You should also use the Keyword syntax if you are creating an application that is intended for use with both FAST Search Server 2010 for SharePoint and SharePoint Server search.

In This Section

• SharePoint Search SQL Query Language Information

• Overview of the SharePoint Search SQL Query

• SELECT Statement in SharePoint Search SQL Syntax

• FROM Clause in SharePoint Search SQL Syntax

• WHERE Clause in SharePoint Search SQL Syntax

• ORDER BY Clause in SharePoint Search SQL Syntax

• SET Statement in SharePoint Search SQL Syntax

See Also

Reference

FullTextSqlQuery

Concepts

Enterprise Search Query Architecture

Keyword Query Syntax Reference