syntax for updatetext

[First Tracks Research]

hello,

i would like to update a column called footer in a table called
agency. i have to update about 60 different records in this table.
footer is varchar(200)

i would like to search for "<table bgcolor="#cccccc"" and replace it
with "<table "

there is stuff before and after the start of the table tag.

i looked at the books online and could not get the syntax correct.

am i using the right command? updatetext, or should i do this with a
loop?

thanks in advance.
nicholas.gadacz

[Shervin]

Nicholas,

This script will do what you want. Don't forget to add a WHERE clause to it
if you want it to check only a portion of your table.

update YourTable
set footer = replace(footer, '<table bgcolor="#cccccc"', '<table ')

Shervin

"First Tracks Research" <in**@ftresearch.com> wrote in message
news:4d**************************@posting.google.c om...

hello,

i would like to update a column called footer in a table called
agency. i have to update about 60 different records in this table.
footer is varchar(200)

i would like to search for "<table bgcolor="#cccccc"" and replace it
with "<table "

there is stuff before and after the start of the table tag.

i looked at the books online and could not get the syntax correct.

am i using the right command? updatetext, or should i do this with a
loop?

thanks in advance.
nicholas.gadacz

[nick gadacz]

what happens if the field is ntext? how does that change the process? do
you have to use updatetext in dealing with that field type?

thanks again.

nicholas.gadacz

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[Shervin]

Yes, you must use UPDATETEXT on text, ntext and image data types. Take a
look at the sample in SQL Server Books Online.

Shervin
"nick gadacz" <in**@ftresearch.com> wrote in message
news:3f***********************@news.frii.net...

what happens if the field is ntext? how does that change the process? do
you have to use updatetext in dealing with that field type?

thanks again.

nicholas.gadacz

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!