http://blogs.msdn.com/b/sqlprogrammability/archive/2006/04/07/570397.aspxWhen comparing two Unicode strings in non-binary collations, SQL Server uses a library that is essentially same as the Windows API CompareStringW. It defines a weight for each recognized character, and then use the weights to compare characters. Howeveren-USTelligent Evolution Platform Developer Build (Build: 5.6.50428.7875)http://blogs.msdn.com/b/sqlprogrammability/archive/2006/04/07/570397.aspx#9706214Mon, 08 Jun 2009 05:01:42 GMT91d46819-8472-40ad-a661-2c78acb4018c:9706214 SQL Programmability amp API Development Team Blog Sorting undefined | Green Tea Fat Burner<p>PingBack from <a rel="nofollow" target="_new" href="http://greenteafatburner.info/story.php?id=5258">http://greenteafatburner.info/story.php?id=5258</a></p> <img src="http://blogs.msdn.com/aggbug.aspx?PostID=9706214" width="1" height="1">