Hi,
I would start by reading this article first, http://www.sqlservercentral.com/articles/Tally+Table/72993/
Its got a great String splitter function.
_________________________________________________________________________
SSC Guide to Posting and Best Practices