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.

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.

In This Section

Enterprise Search SQL Query Language Information

Overview of the Enterprise SQL Search Query

SELECT Statement in Enterprise Search SQL Syntax

FROM Clause in Enterprise Search SQL Syntax

WHERE Clause in Enterprise Search SQL Syntax

ORDER BY Clause in Enterprise Search SQL Syntax

SET Statement in Enterprise Search SQL Syntax

Related Sections

Building Enterprise Search Queries

Enterprise Search Keyword Syntax Reference

Enterprise Search URL Syntax Reference

See Also

Tasks

Walkthrough: Creating an ASP.NET Web Part for the AdventureWorks Business Data Application Sample

Reference

Microsoft.Office.Server.Search.Query.FullTextSqlQuery

Concepts

Enterprise Search Query Object Model Overview
Enterprise Search Query Web Service Overview
Building Custom Enterprise Search Web Parts