sql - UPDATE and REPLACE part of a string - Stack Overflow
https://stackoverflow.com/questions/17365222/update-and-replace-part-of-a-string
WEBJun 28, 2013 · 974. You don't need wildcards in the REPLACE - it just finds the string you enter for the second argument, so the following should work: UPDATE dbo.xxx. SET Value = REPLACE(Value, '123', '') WHERE ID <=4. If the column to replace is type text or ntext you need to cast it to nvarchar. UPDATE dbo.xxx.
DA: 100 PA: 88 MOZ Rank: 59