SQL Server FAQs - Transact-SQL Managing Character Strings and Binary Strings

A collection of 14 FAQs on Transact-SQL language character string and binary string operations. Clear answers are provided with tutorial exercises on concatenating character/binary strings; converting Unicode character strings; converting binary strings; inserting new line characters; locating and taking substrings; bitwise operations.

http://dba.fyicenter.com/faq/sql_server/ransact-SQL_Managing_Character_and_Binary_Strings.html