SQL Extensions in Microsoft Windows Search
Microsoft Windows Search, based on the SQL-92 and SQL-99 standards, improves full-text document-based searches in document-management or knowledge-management applications. Windows Search improvements include the following:
While SQL-92 and SQL-99 restrict column and other identifiers to 18 characters, Windows Search supports 128-character column names. For more information, see Identifiers.
Queries can specify how to group results. You can specify the ranges by which to group, and you can specify more than one column for grouping. For example, you can group results over a range of file sizes (size < 100, 100 <= size < 1000; 1000 <= size), and you can nest groupings. For more information, see GROUP ON ... OVER... Statement.
In addition to searching that is not case-sensitive, Windows Search supports searching that is not sensitive to diacritics (accent marks). For more information, see Diacritic Sensitivity in Searches.
Queries that search more than one column can specify the importance of each column. The CONTAINS and FREETEXT predicates both support column weighting.
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 has a specified property with the value set to NULL, and a document that does not have the property at all.
You can manipulate the search results ranking by using weights on properties and on aliased groups of properties. Rank coercion supports direct manipulation of the relevance ranking based on the criteria you specify.