STUFF is used to replace the part of string with some other string.
STUFF (stringexpression, start, length, replacementcharacters)
SELECT STUFF('Aswini Blog is USEFUL',7,8,'DATABASE')
Aswini DATABASE is USEFUL
REPLACE is used to replace all the occurances of the given pattern in a string.
REPLACE ( string_expression , string_pattern , string_replacement )
I hope it will help you
Mark as answer if it helps you
Saranya Boopathi, if this helps please login to Mark As Answer. | Alert Moderator