try this one

declare @string varchar(20)

set @string='e33,B6661,C1'

select substring(@string,charindex(',',@string)+1,charindex(',',@string,charindex(',',@string)+1)-charindex(',',@string)-1)