SQL Extensions in SharePoint Search
Applies to: SharePoint Server 2010
In this article
128-Character Identifier Names
Accent-insensitive Searching
NULL Predicate
Thesaurus
Microsoft SharePoint Server 2010 search supports SQL search syntax based on the SQL-92 and SQL-99 standards, and improves full-text, document-based searches in document-management or knowledge-management applications. Following are the improvements included in SharePoint Server search.
128-Character Identifier Names
While SQL-92 and SQL-99 restrict column and other identifiers to 18 characters, SharePoint Server search supports 128-character column names.
Accent-insensitive Searching
In addition to searching that is not case-sensitive, SharePoint Server 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 with the property but 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
Reference
SQL Features Unavailable in SharePoint Search