How to replace suffix of data?

[PAVB]

How about something like...

update your_table
set    your_column = replace(your_column, '_TST', '_TRN1')
where  your_column like '%_TST'
;