Just for everyone's benfit, this question has been posted in 6 different threads. I think they've all been linked to this thread now, so we can all work within...

This same question has been asked 6 times in different forums. Please only create one thread per question as it causes confusion for those who frequently answer questions. ...

Triplicate post, please respond here.

Another duplicate post, please contiue this discussion here .

Another duplicate post, please contiue this discussion here .

No problem. I would not be suprised to find that you get some other solutions from some of the other regulars here on SSC. I cringe at the...

OK, that was quicker than I thought. I created a scalar function to be applied to your column. There may be a better way to do this performance...

By the way, this is the quick and dirty example. I realize that your data is in a column in a table, which makes my variable based exmaple not...

This is an easy task for a tally table with a split function. Do you by chance have a numbers table or split function already in your DB?

If not,...

There are other alternatives as well. Can you give us some of the business reasons for wanting to do this? What are you trying to accoplish by switching...

Yea, I figured it to be a 2008 thing, but it's odd that the new syntax still works on my 2005 instance.

Thanks again.

Thanks...

Opportunity.

Yep, you have to do the same thing when using DROP INDEX too.

It looks like the connection manager properties are not being set correctly by the values returned from the for each loop container. Have you tried to toggle the debug...