replace a word in a field

[jmodic]

UPDATE my_table SET addr = REPLACE (addr, 'Street', 'st.');