Replace word using update query

Often we require to replace a word using update query example

Preventive Maintenance PM for testing


here we want to replace PM with FV for that we can create query like


UPDATE PM p
   SET column = REPLACE(p.description, ' PM ', 'FV')