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.
REFERENCES
For more information on SQL Access to Index Server Data, refer to the Index
Server documentation "Creating and Configuring Catalogs" in the Windows NT
Option Pack documentation.
For more details on SQL Server 7.0 distributed and full-text queries, please see sp_addlinkedserver, OpenQuery, OpenRowset, and related topics in SQL 7.0 Books Online.
Keywords: kbinfo kbdatabase KB200862