How to replace string in sql-server?

 Posted by Rajesh_Kumar on 1/21/2014 | Category: Sql Server Interview questions | Views: 2074 | Points: 40
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 

Comments or Responses

Login to post response