• 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