SharePoint Search SQL Syntax Reference
Published: May 2010
Applies to: Microsoft SharePoint Server 2010 searchMicrosoft SharePoint Server 2010 search provides support for constructing complex search queries through the SQL syntax. This syntax is an extension of SQL syntax for querying databases. It is a structured query language that is not intended to be exposed to end-users, but used instead for programmatic creation of queries. SQL can be used only when integrating via the Query or Federation object model and the Query XML Web service. It is not exposed in the search Web Parts. When using SQL syntax with the Query object model, you must use the FullTextSqlQuery class in the Microsoft.Office.Server.Search.Query namespace.
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.