I would like to partially change\update the contents of two fields in SQL. Please see image, the fields contain a name but need to re-name only partially where highlighted. For example where is says
Kirshenbaum Bond Senecal + Partners - OPM Marketing , would like to change it so that it can read - ABC Company - OPM Marketing. Without touching the info after the dash.
There are over 300 rows that need to be changed, would like to test it on one then update both the PRJ_Name and PRJ_DESCRIPT tables. Thanks in advance for you assistance.