Microsoft KB Archive/182829

= DOCERR: Prefix Expansion with Index Server OLEDB Provider 2.0 =

Article ID: 182829

Article Last Modified on 7/19/2001

-

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.

