What is stuff function in sql?

What is stuff function in sql?

The STUFF() function deletes a sequence of characters from a source string and then inserts another sequence of characters into the source string, starting at a specified position.

For Example:

SELECT STUFF('Dotnettricks.guru', 5, 2, '1234');


Result: 'Dotne1234ttricks.guru'