Article ID: 294809 - View products that this article applies to.
This article was previously published under Q294809
This article has been archived. It is offered "as is" and will no longer be updated.
If there are two or more different full-text search enabled columns on a table, and if the keywords separated by the AND operator exist in two different columns, a CONTAINS predicate with the AND operator searches for the keywords across all columns.
For example, assume a table called ftstable with three columns: c1 as integer (the index column), and c2 and c3 as varchar columns that are full-text enabled. Also assume that a row contains "apples" in column c2 and "oranges" in columnn c3. In SQL Server 7.0 SP2 and earlier, the following query
is incorrectly interpreted as follows:
and the row is returned.
NOTE: The correct way to interpret the query is as follows:
and to not return the row.
You can work around this problem in the following ways:
Microsoft has confirmed that this is a problem in the Microsoft products that are listed at the beginning of this article. This problem was first corrected in SQL Server 7.0 Service Pack 3.
Steps to Reproduce Behavior