Hi,

There is a little change in the data..

124546: Kroll, Sam; 548464: Cooper, David; 546546: Hann, John

212132: Payne, Brendon; 545454: Samson, Sara'

212133: Charles; 687465: Anthony; 544654: James; 665465: Charles

123333: Matt, Seamus;...

WOW! It worked...Thank you so much Lynn. You are just amazing..:-D

WOW! It worked..great ....Thank you so much Lynn. You are just amazing..:-D

Thanks a lot Lynn, I tried it. But it only gives the first ID.

The datatype is nvarchar(255).

The value is the string is-

123333: Seamus; 0192543: Annie; 765188: Bruno; 540146: Sekhar; 016633: Berliner; 558314: Martin; 854672: Ryan

My result should be - 123333, 0192543, 765188, 540146,...

Hi Jason-

123333: Seamus; 0192543: Annie; 765188: Bruno; 540146: Sekhar; 016633: Berliner; 558314: Martin; 854672: Ryan

This is the longest string.