Sql server REPLACE function - ASPMANTRA | Asp.Net,MVC,AngularJs,Jquery,Javascript,Sql Server AND WCF snippets and tutorial

Sql server REPLACE function

In this article I am going to explain sql server REPLACE function.

Replace function is used to replace string with another string.  It can be a single or multiple characters.

REPLACE ( string_expression , string_pattern , string_replacement ) 


        1. Replace single character
select REPLACE('articlemirror','r','1') as 'Replace e.g.'
select REPLACE('articlemirror','rro','123') as 'Replace e.g.'

        2. Replace complete string with another
Select REPLACE('asp.net','asp.net','sql server') as 'Replace e.g.'

v  You can also use replace to remove the blank spaces from a column.
select REPLACE(' articlemirror, asp.net   ,    sql server,    mvc ',' ','') as 'Replace e.g.'

Sql server REPLACE function

What do you think about this article?

If you found this article useful, please share and follow on Facebook, Twitter, Google Plus and other social media websites. To get free updates subscribe to newsletter. Please put your thoughts and feedback in comments section.