Knowledge Base

BUG: Wildcard (%) Is Not Recognized in the CONTAINS Clause for a Full-Text Search

Article ID: 203195

Article Last Modified on 5/22/2003

Microsoft SQL Server 2000 Standard Edition
Microsoft SQL Server 7.0 Standard Edition

This article was previously published under Q203195

BUG #: 53491 (SQLBUG_70)

SYMPTOMS

When you use the wildcard character (%) with a word or a phrase in the CONTAINS clause to perform a full-text search on SQL Server character data, the results include the exact word or phrase.

CAUSE

This problem occurs because SQL Server full-text search does not recognize the (%) character as a wildcard character in the CONTAINS clause.

WORKAROUND

To work around this problem, use the (*) character as a wildcard character instead of (%) in the CONTAINS clause to obtain data that contains the specified words or phrases in the CONTAINS clause.

STATUS

Microsoft has confirmed that this is a bug in the Microsoft products that are listed at the beginning of this article.

MORE INFORMATION

This behavior is not documented in SQL Server Book On Line. However, Microsoft will ensure that the SQL code syntax between Microsoft SQL Server and Microsoft Index Server will remain as similar as possible.

REFERENCES

For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

325136 WebCast: SQL Server 7.0 Full-Text Search and Basic Troubleshooting Methods

200043 PRB: Dashes '-' Ignored in Search with SQL Full-Text and MSIDXS Queries

Keywords: kbbug kbnofix kbpending KB203195