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).
Asked In: Many Interviews |
Alert Moderator