• Hi ezhil,

    please check this article ..

    This article has two types of split.

    1. XML split

    2. SQL Function (Basic SQL string split for SQL 2000 or later)

    http://www.sqlservercentral.com/articles/XML/66932/

    With regards,

    Rafidheen.M