What Is Replace Function in Sql Server

Some time we don't need to show the data as it in database for example in SQL Server database i have a table and there is data like Delhi but i want to display it as New Delhi in front end then Replace is very useful inbuilt function in SQL Server. All query which is given in this article is tested in SQL Server 2005 as well as 2008.

REPLACE is inbuilt function in SQL SERVER. REPLACE Take three parameter and syntax of REPLACE function in SQL Server is