Replace and Stuff function in SQL

Question

What is stuff and replace function in SQL and how to use it with sql queries.

Dorababu Meka · Answer

check this article 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 http://www.c-sharpcorner.com/blogs/888/replace-vs-stuff-in-sql-server-2005.aspx