SQL Extensions in Windows SharePoint Services Search

This content is outdated and is no longer being maintained. It is provided as a courtesy for individuals who are still using these technologies. This page may contain URLs that were valid when originally published, but now link to sites or pages that no longer exist.

Windows SharePoint Services 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. Windows SharePoint Services 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, Windows SharePoint Services Search supports 128-character column names.

Accent-insensitive Searching

In addition to searching that is not case-sensitive, Windows SharePoint Services 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

Reference

SQL Features Unavailable in Windows SharePoint Services Search

Concepts

Windows SharePoint Services Search SQL Query Language Information