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 · 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('-'@string0) set @string=SUBSTRING(@stringCharindex('_'@string0)+1LEN(@string)) set @count=@count+1 END select @string=SUBSTRING(@string0Charindex('_'@string0)) select @string Set @string as your column value