Hello all and thanks for the time spend on answering my posted question.

Originally i came across with a similar t-sql already posted by Hugo. That's definitely the simplest and quickest way of doing split string using tally. Thanks Hugo.

Nevertheless i wanted to make sure i could get the same result by using some string functions.

Sorry about the messy code... I should have submitted correctly formatted. :blush: Consider it as an extra level of difficulty. 😉

Anyway, as almost of you got it, the catch was to look to where clause...

My major concern was to post an example of using tally. Back a few months ago i read some articles discussing tally and how to replace cursors and while loops with it and become a huge fan since then. 😀

I know it isn't the best example, but got you guys thinking on it. 😛

Best Regards,

PM