ISABOUT Term

Deprecated

This feature has been removed as of Windows 8. 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.

The ISABOUT term matches columns against a group of one or more search terms. It has the following syntax:

ISABOUT(<components>) [RANKMETHOD <method>]

The optional RANKMETHOD term specifies the calculation method used to rank the documents that match one or more of the components. If no RANKMETHOD is specified, the default Jaccard Coefficient ranking method is used.

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 in the results if at least one of the components matches. Commas separate multiple components.

The component part has the following syntax:

<match_term> [<weight_term>]

You can use the optional WEIGHT term to change the relative importance of each term within the ISABOUT term. If no weight term is applied, the default 1.0 weight is implied.

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 in the CONTAINS Predicate.

...WHERE CONTAINS
 ('ISABOUT ("compu*","soft*")')

Matches "computer", "computers", "computation", and "compulsory"

 

ISABOUT Column Weighting

The ISABOUT term ranks matching documents based on how closely each document matches the set of match terms in the query. You can use column weighting to place more importance on matching some match terms than others. Each match term in the ISABOUT term can have a weight value applied. The weight is applied to a single match term and is indicated by the keyword "WEIGHT". The WEIGHT term has two alternative syntaxes:

<match_term> WEIGHT(<weight_value>)
<match_term>:(<weight_value>)

The weight value must be between 0 and 1.0, with no more than three decimal places. Specifying a weight value outside this range results in an error message. The unweighted ranking value for a term is multiplied by the weight value for the term.

If no weight is specified for a match term, the default value, 1.0, is implied.

Example

The following example applies weights to the two ISABOUT match terms, using both the long and short syntax for weight values.

WHERE CONTAINS( System.FileName,
      'ISABOUT("computer" WEIGHT (0.75),"software":0.25)')

Reference

FREETEXT Predicate

WHERE Clause