INFO: Update to Index Server OLEDB Provider CONTAINS Clause

ID: Q200862

The information in this article applies to:

Microsoft OLE DB Provider for Index Server, version 2.0

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.

Additional query words: kbDSupport

Keywords : kbDatabase kbIdxServ kbSQLServ kbGrpVCDB kbDSupport
Version : WINDOWS:2.0
Platform : WINDOWS
Issue type : kbinfo