看看 REPLACE() 函数:http://msdn.microsoft.com/en-us/library/ms186862.aspx.您应该能够在 UPDATE 语句中使用它来实现所需的结果.

Take a look at the REPLACE() function: http://msdn.microsoft.com/en-us/library/ms186862.aspx. You should be able to use that in an UPDATE statement to achieve the desired result.