my query is below. it works in the sense that it displays a correct list of Part Numbers that have changed. however, when i re query the table to verify the changes, the table hasn't been updated.
i'm assuming i need an UPDATE somewhere in my query... i'm just not sure where.
SELECT REPLACE(dbo.mytable.[Part Number],'R','K')
WHERE [Part Number] like 'DV%R[0-9]%'