SQL Statement

[Mike Norman]

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

[Mike John]

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