Search and replace string inside a column

Update yourtable
Set ColumnA = Replace(ColumnA,'_TH','');