how to replace something across a whole table sql code example

Example: replace content value from old to new sql

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