Great article Mike, thanks, and what a neat little function SetSplit is! I have added it to my toolkit (and given you and SQLServerCentral the credit), but added a second parameter for the character to split the string with.

I had to sit down and figure out how it worked however...

I was wondering how you could number the result set sequentially, so that with you could select from the function to return the nth word in the result set. I don't think you can use an of the methods I would normally use,  IDENTITY(), or count(*) and a GROUP BY

David