Replace is one of the nice function in SQL Server. It's used to replace a particular string in the string.
The Syntax is, 
 

Replace("Actual String","String to be replaced","String to replace")


-------------------------------------------------------------------------
REPLACES THE STRING WITH THE PROVIDED STRING-------------------------------------------------------------------------

 

SELECT REPLACE('VENKAT STRING','VENKAT','SANTHOSH')
The output is SANTHOSH STRING.

Cheers,

Venkatesan Prabu .J
Head - WWW.Kaashivinfotech.com
http://venkattechnicalblog.blogspot.com/