Perfect, it worked great!!! Thanks

quote:

---

DECLARE @CompanyName VARCHAR(xxx)

SET @CompanyName = 'Name of Company'

UPDATE MyTable

SET MyField = REPLACE(MyField, '<companyname>', @CompanyName)

WHERE [Criteria go here]

...

Have you ever visited Plant Source Code? Check out this link for something that might help you with this issue - http://www.planet-source-code.com/vb/scripts/ShowCode.asp?txtCodeId=29526&lngWId=1&txtForceRefresh=124200310111533621.

It may ask you to register...