469,081 Members | 1,894 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,081 developers. It's quick & easy.

SQL Statement

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)
Any help would be greatly appreciated.

Mike Norman
Jul 20 '05 #1
1 1998
Have a look at the 'replace' function in BOL. I can never remember the order or params but it will be something like

update t
set col=replace(col,'project','deliverable')
where col like '%project%'
Mike John

"Mike Norman" <mn*****@hotmail.com> wrote in message news:f6**************************@posting.google.c om...
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)


Any help would be greatly appreciated.

Mike Norman


Jul 20 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

28 posts views Thread by Fábio Mendes | last post: by
13 posts views Thread by eman1000 | last post: by
37 posts views Thread by Steven Bethard | last post: by
18 posts views Thread by Steven Bethard | last post: by
28 posts views Thread by Steven Bethard | last post: by
7 posts views Thread by Steven Bethard | last post: by
18 posts views Thread by dspfun | last post: by
23 posts views Thread by florian.loitsch | last post: by
1 post views Thread by CARIGAR | last post: by
reply views Thread by zhoujie | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.