Windows SharePoint Services Search SQL Syntax
Search in Windows SharePoint Services 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.
Multiple logical operators, such as AND, OR, and NOT. For more information, see WHERE Clause.
Wildcard searches. For more information, see Using Wildcards in the CONTAINS Predicate.
For basic search queries, use the Keyword Syntax reference instead.
The topics in this section describe the SQL syntax used for Search in Windows SharePoint Services.