Luis,

Assuming:

1. That the numbers to be replaced are the only place in the string that any numbers are, and

2. That you want what is to the left of it, plus...

I've got two suggestions to try. Please get back and let us know how they work for you.

The first one moves the correlated subquery in the where clause to a...

I'll bet that those faces are a ":...

I'm glad I was able to straighten it out for you. Thank you for you comments, and I hope to see you more online here!

SELECT column = (select column FROM function (t.address))

FROM Table t

you would have to repeat the call for each column you want.

On 2000, you might want to include an...

LutzM (11/23/2010)

---

The reason you can't use a local temp table in a dynamic sql statement (straight from BOL):

Local temporary tables are visible only to their creators during the same connection...

How does this work for you?

-- See how this starts off with a table and data in it?

-- If you had provided us the data in this format,

-- it...

In this, you are trying to concatenate a string and a table variable together....

The scope of a table variable is the current batch only. It is NOT in scope to any nested procedures, including dynamic sql. So, if you want to use it...

Always a viable option!

No, that's a groan. 😀

Craig Farrell (11/23/2010)

---

GSquared (11/23/2010)

---

If you want, I'll put the whole thing into article form and give it to Steve. Probably should have done that a year ago, when I...

GilaMonster (11/23/2010)

---

CirquedeSQLeil (11/23/2010)

---

GilaMonster (11/23/2010)

---

CirquedeSQLeil (11/23/2010)

---

If you were to buy a SQL book, what would you buy? If there is a topic you wanted to learn about, what is it?...

I like this analogy!

Oh - you don't need the TOP 100 PERCENT on all your queries - all you're doing is making SQL work harder / take longer to return your results.