FROM Clause in Enterprise Search SQL Syntax

Follows the SELECT statement to specify where to search for matching documents.


In Enterprise Search, you can only specify SCOPE() for the scope name. This is a change from Microsoft Office SharePoint Portal Server 2003 Search. In SharePoint Portal Server 2003 Search, you specified the scope name in the FROM clause, for example:

FROM Portal_Content..Scope() WHERE…

For Enterprise Search in Microsoft Office SharePoint Server 2007, you specify the scope name in the WHERE clause, as follows:

FROM Scope() WHERE "scope"='All Sites'…


The scope name is case-sensitive, and you must include double-quotation marks (") around scope.

For information about how to specify search scopes in a query, see "Specifying Search Scopes" in WHERE Clause in Enterprise Search SQL Syntax.

Community Additions