In
this article I will explain what is the replace function in SQL Server and how
to use Replace() function in SQL
Server.

Description:

In
previous post I explained article substring function in SQL server. Now I will explain what
is Replace () function in SQL server
and how to use it in our applications. In one application I got requirement
like replace particular part of the string with another value to achieve this
functionality I realized it’s better to use Replace () function.

Replace() function

This
function is used to replace the all the occurrences of specified string value
with another string value. Generally Replace
function will take 3 arguments and that declaration will be like this