Hi,
Use this to achieve your output
declare @string varchar(20)
set @string='e33-B6661-C1'
select @string
to get the output "B6661-C1"
select substring(@string,charindex('-',@string)+1,len(@string)-charindex('-',@string)+1)
to get the output "C1"
select substring(substring(@string,charindex('-',@string)+1,len(@string)-charindex('-',@string)+1)
,charindex('-',substring(@string,charindex('-',@string)+1,len(@string)-charindex('-',@string)+1))+1,
3)