REPLACE (Transact-SQL)

UPDATE urunler_db SET urun_adi = REPLACE(urun_adi, '0015', '0016');

Replace(sütun adı, eski veri, yeni veri)

REPLACE ( string_expression , string_pattern , string_replacement )

Msdn Page Link