Replace function in SQL Server

Venkatesan Jayakantham
13y
3.4k
0
0

Blog

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')