ASCII

ASCII and CHAR functions

String functions in MS SQL SERVER

Using recursive CTE

Common table expressions (CTE)

LEFT function

String functions in MS SQL SERVER