What is the purpose of STUFF function in SQL Server 2008

Stuff function can be used to insert one string in between another string. It deletes a specified length in the first string and inserts the second string

Example : Consider the string "SQL Server Programming" This can be converted to "SQL Server 2008 Programming" using the below query

Select Stuff('SQL Server Programming',12,0,'2008 ')