STUFF function SQL Server

SQL Server > Built-in Functions > STUFF

STUFF inserts a string into another string

STUFF ( expression , start , length , replaceWith )

Example:

 

SELECT STUFF('abcdef', 1, 2, 'hg');

Result:
hgcdef