Sunday, January 1, 2017

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('','','sql server') as 'Replace e.g.'

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

Sql server REPLACE function

No comments:

Post a Comment