REPLACE

Recursive CTE

Common table expressions (CTE)

String functions in MS SQL SERVER

Transact-SQL string and datetime functions

REPLACE function

String functions in MS SQL SERVER