ISABOUT Term in Windows SharePoint Services Search SQL Syntax
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.
Matches columns against a group of one or more search terms.
Important
While this feature is still supported in the current product version, it may be removed in the future. If you write new applications, avoid using this deprecated feature. If you modify existing applications, you are strongly encouraged to remove any dependency on this feature.
ISABOUT(<components>)
Remarks
The ISABOUT term can have one or more components. The columns specified in the CONTAINS predicate are tested against each component. The document is included with the results if at least one of the components matches. Commas separate multiple components.
Following is the component part syntax:
<match_term>
The following table describes possible match term types.
Type |
Description |
Examples |
|---|---|---|
Word |
A single word without spaces or other punctuation. |
… WHERE CONTAINS ('ISABOUT ("computer","software")') |
Phrase |
Multiple words or included spaces. |
… WHERE CONTAINS ('ISABOUT ("computer software", "hardware")') |
Wildcard |
Words or phrases with the asterisk (*) added to the end. For more information, see Using Wildcards and the Contains Predicate. |
…WHERE CONTAINS('ISABOUT ("compu*","soft*")') Matches "computer", "computers", "computation", and "compulsory". |
See Also
Reference
CONTAINS Predicate in Windows SharePoint Services Search SQL Syntax