Difference in string comparisons between varchar and nvarchar

Quick google search tells it's by design

http://connect.microsoft.com/SQLServer/feedback/details/542220/null-char-0-character-ignored-in-string-comparison

---

For every expert, there is an equal and opposite expert. - Becker's Law





My blog



My TechNet articles