Another question about different stuff 🙂

An interesting example of inserting one string into another. Never thought it could be done that way. I always did it using something like

SELECT LEFT(@string1, 10) + @Stuffing + RIGHT(@string1, LEN(@string1) - 10)