Udate SQL Statement

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Newsgroup \(NNTP\) - 19 Sep 2003 18:39 GMT

I need to replace every instance of a word in our pagecontent table
with new terminology. I need help a script that can be used to mass
replace every occurrence of a word in PageContent. Doing a update
(UPDATE pagecontent SET contentshort = 'Deliverable' WHERE
contentshort Like '%Project%') will replace all the text in the field
to Deliverable. I would need to parse the ContentShort field for items
such as "Mike is a Project Manager" to change to "Mike is a
Deliverable Manager". (Deliverable is the new word for project.)
without taking out the rest of the word. (...is a)

Thanks,
Mike

Reply to this Message

SFAxess - 19 Sep 2003 19:13 GMT

If this is a one-time update, I would backup the table
and use the native Access replace utility. It is the
quick and dirty way.
I have a VBA function I use that does the same thing if
you want that, or you may look in the SQL Server news
groups for someone with a stored procedure or function
that does this on the server.

>-----Original Message-----
>I need to replace every instance of a word in our pagecontent table
[quoted text clipped - 11 lines]
>
>.

Reply to this Message