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/
Next Recommended Reading Some inbuilt functions in SQL Server