These MSSQL internationalization topics provide a link to each specific method.
ASCII
Cast
Convert
LTrim
Replace
RTrim
Soundex
Substring