I have to delete words from a record in the table1. Words to delete are taken from the table 2. I used "select replace (v_1, v_2, '') from ..."
In 2 tables I have records like:
First table: company1 inc, company2 s-corporation, company3 co
Second: inc, co, s-corporation
The point is that words like "inc" are deleted successfully whereas "s-corporation" is counted like "co" and I get "company2 s-rporation" instead of just "company2".
Could u please help me with the task?