How to seprate the values in sql

Hi Dharmesh,

please try with this code:

create table temptable(items varchar(max)) ;

declare @index int  ;     
   declare @values varchar(max) ,@SepValues varchar(max),@Delimiter char(1) ;  
  
   set @SepValues='IT,Design Art,SCO,IT with Mobile,Art with Design pen,ETC' set @Delimiter= ','  
      
   select @index = 1       
        if len(@SepValues)<1 or @SepValues is null  return       
      
    while @index!= 0       
    begin       
        set @index = charindex(@Delimiter,@SepValues)       
        if @index!=0       
           set @values = left(@SepValues,@index - 1)       
        else       
            set @values = @SepValues       
          
        if(len(@values)>0)  
            insert into temptable(Items) values(@values)       
 
        set @SepValues = right(@SepValues,len(@SepValues) - @index)       
        if len(@SepValues) = 0
      break
        end
       
       
        select * from temptable;

Thanks.