STUFF Function and its differences

REPLACE is used to replace all the occurances of the given pattern in a string.

Example: select Replace('Niladri','N','M')

O/P: Miladri

STUFF: This function is used to replace the part of string with some other string.

syntax: STUFF (stringexpression, start, length, replacementcharacters)

Example:SELECT STUFF('My blogs are useful',4,5,'articles')

Output: My articles are useful

In this case , it replaces blogs (which appeared at position 4) with articles

Best Regards,
Niladri Biswas

Saranya Boopathi, if this helps please login to Mark As Answer. | Alert Moderator

Hi Saranya,
STUFF is used to replace the part of string with some other string.
Syntax:
STUFF (stringexpression, start, length, replacementcharacters)
Example:
SELECT STUFF('Aswini Blog is USEFUL',7,8,'DATABASE')
Output:
Aswini DATABASE is USEFUL

REPLACE is used to replace all the occurances of the given pattern in a string.
Syntax:
REPLACE ( string_expression , string_pattern , string_replacement )
Example:
select Replace('Aswini','W','S")
Output: Assini

I hope it will help you
Mark as answer if it helps you
Thanks&Regards

Mark as Answer if it helps you
Thanks&Regards
Aswini Aluri

Saranya Boopathi, if this helps please login to Mark As Answer. | Alert Moderator