LEN
LEN() function, trailing spaces and uniqueness
LEN function
Recursive CTE
Common table expressions (CTE)
LEN function
String functions in MS SQL SERVER
SUBSTRING function
String functions in MS SQL SERVER
REPLACE function
String functions in MS SQL SERVER
REPLICATE and STUFF functions
String functions in MS SQL SERVER