REPLACE FUNCTION IN T-SQL

Replace Function:

Replace (string1,string2,string3)
ShortCut to Remember:  Replace (E,S,R)
E- Expression
S-Search
R-Replace

string1- It is the string expression to be searched.
string1 can be of a character or binary data
type.

string2- it is the substring to be forund. string2 ca be of a character or binary data t
type.

string3:- it is the replacement string. string3 can be of a character or binary data type.


Return types::
1. Return nvarchar if one of the input argumnets is of the nvarchar data type; otherwise, replace returns varcha.

2. Returns NULL if any one of the arguments is NULL.