declare @no char(100)
set @no='abc,cdesefd,efddc,mgns,aa,cdesefd,efddc,mgns,aa,cdesefd,efddc,mgns,aa,cdesefd,efddc,mgns,aa,cdesefd,efddc,mgns,aa,cdesefd,efddc,mgns,aa,cdesefd,efddc,mgns,aa,cdesefd,efddc,mgns,aa,cdesefd,efddc,mgns,aa,cdesefd,efddc,mgns,aa,cdesefd,efddc,mgns,aa,cdesefd,efddc,mgns,aa'
select * from fn_Split(@no,',')