Thanks, this helped me come up with a way to resolve the same issue.

update ITEMS

set description = convert(text, replace(CONVERT(varchar(max),description), 'old string', 'some other string'))

from ITEMS

where description like '%old string%'

Julie

"Half the Sky" quotes a story about Bill Gates giving a talk in Saudi Arabia (I think). The room is 3/4 men and 1/4 women. The women are partitioned off...

Some people's idea of a backup is having their resume up-to-date and access to a copier.

😛

I usually say yes, too. I've been lucky that it's rare for people to abuse it (with me anyways). I ended up staying 'til midnight once (I rarely work more...

I believe I would chose my integrity also. But until one is actually in that position, one can't be absolutely certain.

It would appear likely that quite a few people in the companies that purchased stolen information would have known or had reason to know that this information was stolen. Have...

There were two different crimes here. The stealing of the data is the one that is receiving the most attention. But what about the companies that received and made use...

Please post your solution so that others may benefit.

Julie

I wasn't aware...

crookj (10/26/2009)

---

Another this to keep in mind is...

How many of your peers, subordinates, and supervisors classify you as one of the Smart People that they like to be around?

Surround your...

I find conferences recharge my batteries, too, even though I often feel tired at the end of each day. It's not just the sessions, but the interactions between sessions that...

It's important to remember that while this site was created mainly for DBA's (I believe) that there are many others who have found this to be a valuable site also....

Showing appreciation is important, but it's more meaningful if it's specific, timely, and sincere. "Nice job" is positive but not particularly meaningful. I once wrote a brief note of appreciation...

I'm a boomer (57) . My mother (90) makes use of some technology. Her baby sister (76) teaches her new things. In part, I think people embrace the technologies that...

nelsonj-902869 (9/22/2009)

---

While I agree that networking is a vital part of staying in touch for any new position, should you happen to be looking for a new one, there are...