REPLACE STRING IN SQL SERVER 2005

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,

Advertisement