john.arnott (6/25/2010)

---

If you've been at this game for three decades, then you must have used COBOL. Think of how that language handles trailing spaces in comparisons. Or is it...

Adam Haines (6/25/2010)

---

While this is true.... a string is a string, but the deviation here is the method used to evaluate the strings. Part of the ANSI standard is...

This is what I absolutely hate about SQL Server. A string is a f**king string, no matter whether it's got spaces on it at the end.

Jeez.