SQL split a comma separated string

SQL split a comma separated string


 DECLARE @valueList varchar(8000)  
 DECLARE @pos INT  
 DECLARE @len INT  
 DECLARE @value varchar(8000)  
 DECLARE @i INT=0  
 SET @valueList = ',Atik,Khabir,Shahed,Shain,Ashek,Noman'  
 set @pos = 0  
 set @len = 0  
 WHILE CHARINDEX(',', @valueList, @pos+1)>0  
 BEGIN  
   set @len = CHARINDEX(',', @valueList, @pos+1) - @pos  
   set @value = SUBSTRING(@valueList, @pos, @len)  
      set @i=@i+1   
   --SELECT @pos, @len, @value /*this is here for debugging*/  
     IF(@i=1) -- now you can set condition  
           BEGIN  
            PRINT @value   
           END  
            IF(@i=2)  
           BEGIN  
            PRINT @value   
           END  
            IF(@i=3)  
           BEGIN  
            PRINT @value   
           END  
            IF(@i=4)  
           BEGIN  
            PRINT @value   
           END  
   set @pos = CHARINDEX(',', @valueList, @pos+@len) +1  
 END  


Popular posts from this blog

WPF Crystal Report Viewer Using SAP

ASP.NET MVC razor SAP Crystal report