I need to update part of the string in SQL Server.
I have:
ID IDCityVisited Names
1 10 Julya,Matheus,Donovan
2 15 Mary,Donovan,Richard
3 20 John,Bob,Andy
I need to update the Names column changing only Donovan for Paul and keeping all the remaining string as it is.
Thanks
As @Pondlife point me, this worked:
UPDATE myTable
SET Names= REPLACE(Names, 'Donovan', 'Paul')
WHERE Names LIKE '%Donovan%'
Thanks All
You need to update your table
UPDATE tblName
SET Names = REPLACE(Names,'Donovan','Paul')
I think you need to take SQL server Beginning lesson very serious.
This is what you want to do. a simple replace function will work on your question.
This query will filter the record for Id = 2 then replace function will replace Donovan with Paul.
Update TableName
set Names = replace(Names,'Donovan','Paul')
where Id = 2
UPDATE table SET names = REPLACE(names,'Donovan','Paul')
Try this:
UPDATE
Tbl
SET Names = REPLACE(Names, 'Donovan','Paul')
WHERE PATINDEX('% Donovan %', Names) != 0
or this, if you have full-text index on Names
UPDATE
Tbl
SET Names = REPLACE(Names, 'Donovan','Paul')
WHERE CONTAINS(Names, 'Donovan')
