Replace function in SQL Server

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/