ÿþDECLARE @nstring nchar(8) SET @nstring = N'`O}Y' SELECT UNICODE(SUBSTRING(@nstring, 2, 1)), NCHAR(UNICODE(SUBSTRING(@nstring, 2, 1))) /* Result is: ----------- ---- 22909 }Y (1 row(s) affected) Where 22909 = 0x597D, which is in fact the code of the string's 2nd character: "}Y" (hao3). */