Example
Delete 3 characters from a string, starting in position 1, and then insert “HTML” in position 1:
SELECT STUFF('SQL Tutorial', 1, 3, 'HTML');
Definition and Usage
The STUFF() function deletes a part of a string and then inserts another part into the string, starting at a specified position.
Tip: Also look at the REPLACE() function.
Syntax
STUFF(string, start, length, new_string)