ASCII

ASCII and CHAR functions

String functions in MS SQL SERVER

Recursive CTE

Common table expressions (CTE)

LEFT function

String functions in MS SQL SERVER