SQL Extensions in SharePoint Foundation Search
[This documentation is preliminary and is subject to change.]
Microsoft SharePoint Foundation 2010 Search supports SQL search syntax based on the SQL-92 and SQL-99 standards, improves full-text, document-based searches in document-management or knowledge-management applications. SharePoint Foundation 2010 Search improvements include the items identified below.
128-Character Identifier Names
While SQL-92 and SQL-99 restrict column and other identifiers to 18 characters, SharePoint Foundation Search supports 128-character column names.
Accent-insensitive Searching
In addition to searching that is not case-sensitive, SharePoint Foundation Search supports searching that is not sensitive to accent.
NULL Predicate
Although full-text content indexing has no defined set of columns, queries can require that members of the result set do or do not have specified columns. It is not possible to differentiate between a document that has the property and its value is NULL, and a document that does not have the property.
Thesaurus
The thesaurus is a query-expansion search feature that allows you to type a phrase in a search query and receive results for related words. The thesaurus also enables you to affect search ranking by assigning weights to words.
See Also
Concepts
SharePoint Foundation Search SQL Query Language Information