DOCERR: Prefix Expansion with Index Server OLEDB Provider 2.0

ID: Q182829

The information in this article applies to:

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          : oledbProvIndex 
Version           : WINDOWS:2.0
Platform          : WINDOWS
Issue type        : kbinfo

Last Reviewed: April 16, 1998