Knowledge Base

DOCERR: Prefix Expansion with Index Server OLEDB Provider 2.0

Article ID: 182829

Article Last Modified on 7/19/2001

APPLIES TO

This article was previously published under Q182829

SUMMARY

The Microsoft OLE DB Provider for Index Server 2.0 supports searching for prefix expansion (wildcards) in the CONTAINS predicate of the WHERE clause of a SQL statement.

MORE INFORMATION

Following is the correct syntax to use prefix expansion (wildcards) in the CONTAINS predicate of the WHERE clause of a SQL statement: 
   CONTAINS ( [ column_reference, ] ' "Word_or_Phrase*"
   [ Boolean_Operator "Word_or_Phrase" ] ... ' ) > 0
To find all words that begin with "Inter", you should use the following: 
   CONTAINS('"Inter*"') > 0
The Online help for the CONTAINS predicate in Index Server 2.0 documentation contains an incorrect example that is missing the double quotes required for prefix expansion.

REFERENCES

For more information on Index Server OLEDB Provider 2.0, refer to the Index Server documentation in the Windows NT Option Pack documentation.

Keywords: kbinfo KB182829


Send feedback to Microsoft

© Microsoft Corporation. All rights reserved.