SUBSTRING

Recursive CTE

Common table expressions (CTE)

String functions in MS SQL SERVER

Transact-SQL string and datetime functions

SUBSTRING function

String functions in MS SQL SERVER