SQL query to get value after four _ symbols

Question

Hi,
I am trying hard to get one value from database.
my database value is some thing like
yxmn_euheiu_uhfi_jdfhf_ A6 _hfurh
dsfsdgdf_dsgrgrd_rshrfhfd_hsdsg_ B5 _Dgsdgd_asgsgsd
My output should only  A6, B5 values from database.
A6, B5 gets only after four "_" symbols.
Please help me to write sql query.
Darma

Santhosh Kumar Jayaraman · Accepted Answer

try this
declare @string as nvarchar(1000) set @string='yxmn_euheiu_uhfi_jdfhf_A6_hfurh' declare @count as int=0 While (@count BEGIN print Charindex('-',@string,0) set @string=SUBSTRING(@string,Charindex('_',@string,0)+1,LEN(@string)) set @count=@count+1 END select @string=SUBSTRING(@string,0,Charindex('_',@string,0)) select @string
Set @string as your column value