Search and replace string inside a column

Do like this

declare @str nvarchar(40)
set @str='Test_TH'

select replace(@str,'_TH','')

---

Many Thanks & Best Regards, Hua Min