这是使用 REPLACE 函数

要从 SELECT 查询中的SomeTable"中的SomeColumn"中去除somestring":

To strip out "somestring" from "SomeColumn" in "SomeTable" in the SELECT query:

SELECT REPLACE([SomeColumn],'somestring','') AS [SomeColumn]  FROM [SomeTable]

更新表格并从SomeTable"中的SomeColumn"中去除somestring"

To update the table and strip out "somestring" from "SomeColumn" in "SomeTable"

UPDATE [SomeTable] SET [SomeColumn] = REPLACE([SomeColumn], 'somestring', '')