Hello dear,

please tryout this . I assume from your query string is not limited to 2 commas .

Declare @strsql varchar(50),@chrindex int

set @strsql = 'AA,BB,C,D'

select @strsql --print original val

select @chrindex=CHARINDEX(',',@strsql,1)

select SUBSTRING(@strsql,1,@chrindex-1)--output1

while @chrindex > 0

begin

set @strsql= SUBSTRING(@strsql,@chrindex+1,LEN(@strsql))

select @chrindex=CHARINDEX(',',@strsql,1)

if @chrindex >0 select SUBSTRING(@strsql,1,@chrindex-1) -- output2

end

select @strsql --output3