Jeff Moden (1/19/2009)

---

I guess that's what I'm getting at, folks. My answer to such a question in an interview would be to first answer the question correctly as many...

Too many possibilities to come to any real conclusions. We need more information from the OP...

Yep.

This sounds a lot like homework?

For the record,...

Heh, I guess that depends on who's asking. 😛

Thanks for the feed back.

NO. It does not.

Have you tried a trace or Profiler?

Here's another way to go:

--Test:

Select

Replace( Replace(ColumnName, '_5X7', '5X7'), '5X7', '_5X7')

From YourTable

Where ColumnName like '5X7'

--change:

Update YourTable

Set ColumnName

= Replace( Replace(ColumnName, '_5X7', '5X7'), '5X7', '_5X7')

...

RBarryYoung (1/17/2009)

---

Jeff Moden (1/17/2009)

---

Correct. But even the estimated execution plan is "wonky" in that respect. I don't have the code example to prove it, but I've seen...

Glad I could help.

As you say Gail, however, this is a case where, as documented, it is supposed to work.

GilaMonster (1/15/2009)

---

Just note with the solutions above, there's no guarantee of order. It may come out in the order you want, it may not. There's a trick with FOR XML...

Well this would be easier if you would tell us what the error is. And also show us the full foreign key definition & details which this screenshot does...