I have a column with organization names that includes a year in parentheses at the end. I need to remove the year and the surrounding parentheses for each record. The year is variable. Here is an example:
Department of Housing (1993)
I want the field to be simply:
Department of Housing
I have tried a number of combinations of REPLACE, CONCAT, and LIKE but can't get anything to work. Can you provide a same UPDATE command that will accomplish this?