ID: Q182829
The information in this article applies to:
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.
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.
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