CHAR (Transact-SQL)

The following example prints the ASCII value and character for each character in the string New Moon. Copy SET TEXTSIZE 0; -- Create variables for the character string and for the current -- position in the string. DECLARE @position int, @string char(8);

msdn.microsoft.com