Greg Snidow (1/11/2012)
The 'B' shows up no matter what I put in for the length parameter of CHAR. I still don't know what it means.
So 'B' is just ASCII character 66 = 0x42. The second byte of the binary is zero, and ASCII(0) is interpreted by SQL Server Management Studio as end-of-string when displaying grid view results. Thank you Drew.
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi