Encontre e substitua uma string em uma tabela

Encontre e substitua uma string em uma tabela 

<SPAN >A stored procedure a seguir encontrará e substituirá uma string em uma tabela tabela:</FONT></FONT></SPAN><SPAN > </FONT></SPAN>

<SPAN lang=EN-US >CREATE PROCEDURE [dbo].[sp_st_FindANDReplaceString]<BR></FONT></FONT></SPAN><SPAN lang=EN-US >@Tablename<SPAN >  </SPAN>varchar(20),<BR></FONT></FONT></SPAN><SPAN lang=EN-US >@FieldName<SPAN >  </SPAN>varchar(20),<BR></FONT></FONT></SPAN><SPAN lang=EN-US >@FindString<SPAN >  </SPAN>varchar(30),<BR></FONT></FONT></SPAN><SPAN lang=EN-US >@RepalceString<SPAN >  </SPAN>varchar(30)<BR></FONT></FONT></SPAN><SPAN lang=EN-US >AS</FONT></FONT></SPAN><SPAN lang=EN-US > </FONT></SPAN>

<SPAN lang=EN-US >declare @sqlstring varchar(8000)</FONT></FONT></SPAN><SPAN lang=EN-US > </FONT></SPAN>

<SPAN lang=EN-US >Select<SPAN >  </SPAN>@sqlstring<SPAN >  </SPAN>= "Update " +<SPAN >  </SPAN>@Tablename + " Set " +<SPAN >  </SPAN>@FieldName + "<BR></FONT></FONT></SPAN><SPAN lang=EN-US >= Replace(" + @FieldName + ",'" +<SPAN >  </SPAN>@FindString + "','" + @RepalceString<SPAN >  </SPAN>+ <BR></FONT></FONT></SPAN><SPAN lang=EN-US >"')"</FONT></FONT></SPAN>

<SPAN lang=EN-US ></FONT></SPAN>

<SPAN lang=EN-US >execute (@sqlstring)<BR></FONT></FONT></SPAN><SPAN lang=EN-US >GO</FONT></FONT></SPAN>

<SPAN lang=EN-US ></FONT></SPAN>

<SPAN lang=EN-US >EXEC sp_st_FindANDReplaceString ('Orders','ShipName','QUICK','SLOW')</FONT></FONT></SPAN>

Isto substituirá a palavra QUICK para SLOW no campo SshipName da tabela Orders.