I have a sql 2012 database with different types of field values in one field. I need to rename those values so they equal what the values should be for that field.
Field Name is Repository_revisions
the value in that field is ORD_DS_1111111_DATE_02.pdf
I need to change this value to ORDERS_DOCKETSHEET_1111111_DATE_02.pdf.
There is over 10,000 records that I will need to change. I am fairly new to SQL 2012 and any help will be appreciated.