Microsoft KB Archive/200862

= INFO: Update to Index Server OLEDB Provider CONTAINS Clause =

Article ID: 200862

Article Last Modified on 7/19/2001

-

APPLIES TO


 * Microsoft OLE DB Provider for Index Server 2.0

-



This article was previously published under Q200862



SUMMARY
The original release of the Microsoft OLE DB Provider for Microsoft Index Server 2.0 with Windows NT Option Pack 4.0 requires a "> 0" at the end of the CONTAINS predicate in the WHERE clause, as given below: CONTAINS ( [Column_Reference, ] ' Content_Search_Conditions ') > 0 However, later updates to the Provider (included with Far East release of the Windows NT 4.0 Option Pack as well as Windows NT 4.0 SP4) have made it optional to use "> 0" at the end of the CONTAINS predicate. The Provider now accepts both notations to retain backward compatibility.



MORE INFORMATION
When using a SQL Server 7.0 distributed query to a file system with Index Server OLEDB provider and with SQL full-text search of character data stored in SQL Server, you don't need to use "> 0" at the end of the CONTAINS predicate in the WHERE clause.

