DBCS String Comparisons (Level 4)

SQL Server 6.x	SQL Server 2000
When comparing DBCS space characters, the Unicode A140 space character (U-A140) was not equal to the Unicode 0020 (U-0020) space character.	Comparisons involving the Unicode A140 space character (U-A140) are now equivalent to the Unicode 0020 (U-0020) space character. Expect different results as compared to earlier versions of SQL Server when comparing DBCS space characters.