I've got a table with two columns,
ID
and Value
. I want to change a part of some strings in the second column.
Example of Table:
ID Value
---------------------------------
1 c:\temp\xyz\abc\111
2 c:\temp\xyz\abc\222
3 c:\temp\xyz\abc\333
4 c:\temp\xyz\abc\444
Now the
xyz\
in the Value
string is not needed.
For
UPDATE
and REPLACE
the same, use below SQL query :UPDATE dbo.xxx
SET Value = REPLACE(Value, 'xyz\', '')
WHERE ID <=4
you can read more about REPLACE here .