Microsoft KB Archive/203195

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

Article ID: 203195

Article Last Modified on 5/22/2003

-

APPLIES TO


 * 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.

