STUFF Function in SQL Server
STUFF function is used to replace a string with another string within a text. This function can be very helpful in some situation.
Here you can see the syntax of this function along with the example:
STUFF ( character_expression1 , start , length , character_expression2 )
SELECT STUFF( SQL SERVER is USEFUL' , 5 , 6 , 'DATABASE')
SQL DATABASE is USEFUL