replace pk data in sql code example

Example 1: replace string value in sql

UPDATE tableName  SET  fieldName = REPLACE(fieldName, 'fromStringValue', 'toStringValue');

Example 2: replace content value from old to new sql

Update  tbl.Products
Set articlenumber = replace(articlenumber, 's401', 'I00010')