SQL Replace substring

[PhantomIII]

Any help on the following would be much appreciated

 

I want to replace part of a string with something else via sql.

 

String = "Scotland:Glasgow:England:London:Scotland:Dundee"

 

say i wanna replace Scotland:xxxx with Ecosse:xxxx =Yes

 

where xxx could be Glasgow / Dundee etc

 

so after conversion string should read

 

 

"Ecosse:Glasgow=Yes:England:London:Ecosse:Dundee=Yes"

Edited February 9, 2004 by Derek Stone

[Derek Stone]

Use the T-SQL REPLACE() function.