I’ve a database value
'INS. Company Cancelled' where multiple values are separated by
I’m trying to replace
'INSEXP' my expected result is
'INSEXP. Company Cancelled'
I’ve tried below two queries to update the field my output is like
'INSEXP. Company Cancelled. Company Cancelled'
update my_table SET column_name = (select replace(column_name, 'INS', 'INSEXP') from my_table WHERE seq_num = 123) WHERE seq_num = 123; update my_table set column_name = replace(column_name, 'INS', 'INSEXP') WHERE seq_num = 123;
Could someone please tell me what I’m doing wrong here?