Search and Replace with Table rows

  • Thread starter Thread starter ms newsgrp
  • Start date Start date
M

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.
 
UPDATE table SET description = REPLACE(description, 'Michael S.', 'Jacob
S.')

?
 
Back
Top