SQLREPLACE方法

SELECT REPLACE('abcdefghicde','cde','xxx')
GO


UPDATE Stu set name = REPLACE(name,'abc','')