DOCERR: Prefix Expansion with Index Server OLEDB Provider 2.0 (182829)


The information in this article applies to:

  • Microsoft OLE DB Provider for Index Server 2.0
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.
Modification Type:MajorLast Reviewed:7/19/2001
Keywords:kbinfo KB182829
©2002 Microsoft Corporation. All rights reserved.