INFO: Update to Index Server OLEDB Provider CONTAINS Clause (200862)


The information in this article 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.
Modification Type:MajorLast Reviewed:7/19/2001
Keywords:kbDatabase kbDSupport kbinfo KB200862
©2002 Microsoft Corporation. All rights reserved.