How can I view special characters in SQL Server 2012 Management Studio grid view?
I found viewing the data as binary was the way to go for me:

SELECT @String as MyString, CAST(@String as varbinary(max)) MyString_In_Hexidecimal;


I found an ASCII table then helped decipher what was in the string.