vk-kirov (11/22/2012)

---

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)

At first sight it might not be clear directly how to insert a character (or a string) instead of substituting characters in the original string.


To insert a string, without replacing/substituting characters in the original string you need to specify a length of 0 (zero).
SELECT STUFF('abcghi', 4, 0, 'DEF');
-- this results in 'abcDEFghi'.