MSDN Library
Office Development
2007 Microsoft Office System
SharePoint Server 2007
SDK Documentation
General Reference
Searching in Office SharePoint Server 2007
Querying Enterprise Search
Building Search Queries

SQL Syntax

Query Language Information
Overview of the SQL Search Query
SELECT Statement
FROM Clause
WHERE Clause
ORDER BY Clause
SET Statement

Related Links

Keyword Syntax
URL Syntax

Enterprise Search SQL Syntax Reference

Enterprise Search SQL Syntax Reference

Enterprise Search in Microsoft Office SharePoint Server 2007 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 in Enterprise Search SQL Syntax.
Multiple logical operators, such as AND, OR, and NOT. For more information, see WHERE Clause in Enterprise Search SQL Syntax.
Wildcard searches. For more information, see Using Wildcards in the CONTAINS Predicate in Enterprise Search SQL Syntax.

Note:
For basic search queries, use the Enterprise Search Enterprise Search Keyword Syntax Reference instead.

You can use SQL syntax for search queries with the Query Web service or the Query object model. When using SQL syntax with the Query object model, you must use the FullTextSqlQuery class in the Microsoft.Office.Server.Search.Query namespace.

The topics in this section describe the SQL syntax used for Enterprise Search.