SQL Server 2008 Empty String vs. Space
varchars and equality are thorny in TSQL. The LEN function says: Returns the number of characters, rather than the number of bytes, of the given string expression, excluding trailing blanks. You need to use DATALENGTH to get a true byte count of the data in question. If you have unicode data, note that the value … Read more