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

The CONTAINS predicate supports the use of the asterisk (*) as a wildcard character for words and phrases. You can add the asterisk only at the end of the word or phrase. The presence of the asterisk enables the prefix-matching mode. In this mode, matches are returned if the column contains the specified search word with zero or more other characters. If a phrase is provided, matches are detected if the column contains all the specified words with zero or more other characters.

Examples

The first example matches documents that have any word in the Description column beginning with "serve".

…WHERE CONTAINS(Description, 'serve*')

The second example matches documents with any phrases in the Description column that begin with "comp" and in which the next word begins with "serve". For a document to match, it must match all the terms.

… WHERE CONTAINS(Description, 'comp serve*')

Remarks

The asterisk works only for prefix-matching; it does not work for suffix-matching.

See Also

Reference

CONTAINS Predicate in Windows SharePoint Services Search SQL Syntax