Replace and Stuff function in SQL

STUFF() can be used to stuff a string into another string. It inserts the string at a given position, and deletes the number of characters specified from the original string. 

REPLACE() replaces all the specified characters with new characters. 

For example check this article