How to replace string in SQL Server?

Introduction: 
--------------------
Here i will give an example how to replace a substring in a string in SQL Server. 
For example you want to change domain in Employee email addresses in 'EmployeeDetails' table.

In the below example i am replacing  EmailId  from "@gmail.com" to "studentboxoffice.in" in 'EmployeeDetails' Table .

Example: 1)
-------------------

Declare @txt1 varchar(50)
set @txt1 = 'vikramreddy@gmail.com'
/* Here i am replacing @gmail.com to @studentboxoffice.in */
set @txt1 = REPLACE(@txt1, '@gmail.com', '@studentboxoffice.in')
select @txt1
Output:
--------------
vikramreddy@studentboxoffice.in


Exmple: 2)
----------------

You can also update employee emailid in 'EmployeeDetails' table. 

-- before update EmailID = 'vikramreddy@gmail.com'

update    EmployeeDetals 
set        EmailID = REPLACE(EmailID, '@gmail.com', '@studentboxoffice.in')
where    EmployeeCode = 3151

-- After updating EmailID = 'vikramreddy@studentboxoffice.in'