What is the output of below code?

declare @str navrchar(50);
set @str = 'Rajesh Kumar';
Select Replace(@str,'Kumar','Sathua') as 'New Value';

Answer:

Output would be Rajesh Sathua.As we know that Replace function replace the text from given string.Here 1st expression is rajesh kumar,i want to replace kumar with sathua,so i will pass kumar in 2nd parameter and new value will be passed in 3rd parameters.