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


The information in this article applies to:

  • Microsoft SQL Server 2000 (all editions)
  • Microsoft SQL Server 7.0
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

Modification Type:MajorLast Reviewed:5/22/2003
Keywords:kbnofix kbbug kbpending KB203195 kbAudDeveloper
©2002 Microsoft Corporation. All rights reserved.