How can I change the following so
REPLACE "writes" changes to the database
instead of the current "display new results,
don't write changes" like it currently does ?
SELECT REPLACE(NAME,
SUBSTRING(NAME, CHARINDEX('2004',
NAME), 4), '2005')
FROM dbo.[PRODUCT]
WHERE (NAME LIKE '%2004%')