REPLACE

Replaces all occurrences of the second given string expression in the first string expression with a third expression.

Syntax

REPLACE ( 'string_expression1' , 'string_expression2' , 'string_expression3')

Examples

This example replaces the string in “Testing Replace String” with Testing Replace String

SELECT REPLACE('"Testing Replace String"','"','')
GO

Here is the result set:


----------------------------
Testing Replace String
(1 row(s) affected)
----------------------------
Another example is in the following code