Article ID: 295045 - View products that this article applies to.
This article was previously published under Q295045
BUG #: 352092 (SHILOH_BUGS)
The collation SQL_Latin1_General_Pref_Cp1_CI_AS has an expected behavior of case insensitivity, where an "a" is collated the same as an "A". In certain SQL Server 2000 fixes, when you use SELECT DISTINCT to select data, uppercase and lowercase versions of the same data (such as "a" and "A") may both be returned.
This behavior is not observed in the release build of SQL Server 2000, but may be observed in some fixes.
To resolve this problem, obtain the latest service pack for SQL Server 2000. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/290211/EN-US/ )INF: How to Obtain the Latest SQL Server 2000 Service Pack
Microsoft has confirmed that this is a problem in SQL Server 2000. This problem was first corrected in SQL Server 2000 Service Pack 1.
To test if the problem exists on the build that you are running, execute the following T-SQL code from Query Analyzer:
The expected behavior is to return three rows, but the versions affected by this bug will return six rows.