• Just tried the XML version with a short test string.

    SELECT * FROM dbo.Split(N'03680027,08563027,03682027,03677003,03683027,17948027,03702003,17948003,15636003,03620003,03299003,03014003,03679027,08563003,03013003,15636027,00781003,35879049,03682003,03683003,03679003,03680003,30441003,02747049,02748049,02749049,03300003,02981003,02981027,02981004,02982003,02982027,02982004,02983003,02983027,02983004,06921003,02974003,02974027,02974004,02975003,02975027,02975004,02973003,02973027,02973004', N',');

    Looks really good. Seems to perform just as quickly as the one I use with the Tally Table.

    Thank you.

    Sandor