0
SQL Replace Function
Posted by Rajendra Prasad Panchati
on
Thursday, February 11, 2010
in
SQL Server
REPLACE : This function is used to replace partial or total string from your original string.
Syantax: REPLACE(base string,subString of base string,string to be replaced)
Ex: REPLACE('My Name is Rajendra",'Rajendra','Your Name')
Output: 'My Name is Your Name'.
Syantax: REPLACE(base string,subString of base string,string to be replaced)
Ex: REPLACE('My Name is Rajendra",'Rajendra','Your Name')
Output: 'My Name is Your Name'.
More
Less