How to replace string in sql-server?

Answer:

With the help of Replace in-built sql-server function,we can replace any text within sql-server.It takes 3 parameters as

Syntax:

Replace('string text','searched string','replaced string');

String Text:- It can be any string.
Searched String:- The text to be searched from within 1st parameter i.e. string text.
Replaced String:- This is the new value or text which will replace 2nd parameter value(searched string) from 1st parameter value(string text).