• You can use the DelimitedSplit8K function for your requirement

    SELECTPMI.pmid, DS.Item

    FROMPMInfo AS PMI

    CROSS APPLY dbo.DelimitedSplit8K( PMI.member, '-') AS DS

    The code for the function is present in the article by Jeff Moden below

    http://www.sqlservercentral.com/articles/Tally+Table/72993/


    Kingston Dhasian

    How to post data/code on a forum to get the best help - Jeff Moden
    http://www.sqlservercentral.com/articles/Best+Practices/61537/