Replace word in a text field with value from another field.

[Leigh Lambert]

HI All,

I have searched and not found an answer to this. I am not sure it can even be done, but here is a shot.

I have a table that is populated with data, we have added an additional description field to the table that I need to update with text along with a value from another field in the same table.

Here is is....

table is named "pmd.locations" fields in this table include "name" and "description2"

I want to be able to run an update statement to set the value of
description2 = '<p><strong><??? Roofers &amp;&nbsp;??? Roofing Services</strong></p>

where the ??? is replaced with the name field.

I thought I might need to update the description2 field and then do a select replace but not sure of the syntax.....

Thank you so much for any help you can provide me.