Microsoft SQL Server A Better Search and Replace for Your Database by Bo Jensen • marts-23-2011 UPDATE myTable SET myColumn = Replace(Cast(myColumn AS NVARCHAR(Max)), 'rob conery', 'jon galloway') A Better Search and Replace for Your Database