Search and Replace with Table rows

[ms newsgrp]

I need to search and replace a word in a field (description) in the table
(TableInventory) in my database? I need to replace 'Michael S.' with 'Jacob
S.' within the text string.

How can I do this with SQL and TSQL?

I need to search and replace in all the rows in the table.

Thanks in advance.

 

[Aaron [SQL Server MVP]]

UPDATE table SET description = REPLACE(description, 'Michael S.', 'Jacob
S.')

?