Replace: SQL Server String Function

REPLACE is the string function in sql server which is used to replace a string with new string in main string for all the occurance.

let say RANDHEER is the main string and in this i want to replace E with I then if i use replace it will replace all E's with I in RANDHEER. The result will be something like RANDHIIR.

SYNTAX for REPLACE:

REPLACE( MAIN STRING , STRING TO BE REPLACED , NEW STRING WHICH WILL REPLACE)

Keywords:SQL SERVER STRING FUNTIONS