update syntax question 1

[Luvsql]

I have a table with data in a field X like (.NAME1.NAME2.NAME3.) I would like to update this field and remove any occurences of 'NAME2.

I tried an update using set, then replace function, but it didn't work. Any thoughts?

 

[SQLDenis]

Update table
set x= replace(x,'NAME2.','')
where x like '%NAME2%'

Denis The SQL Menace
SQL blog:

http://sqlservercode.blogspot.com/

Personal Blog:

http://otherthingsnow.blogspot.com/

 

[druer]

You might want to fire a second query after the preivous one using ".name2" in case you have situations where "name2" is the last in the text. But it wouldn't update those cases where "name2" was the first one.

Hope it helps,
Dalton