I am looking for solution to extract text after second occurrence of underline character in string, but if there any others following underline characters in extracted text I also want to remove them i.e.
aaa_bbb_ccc -> ccc
ddd_eee_ff_ggg -> ff
hhh_iii_jjjjjj_kkk_lll -> jjjjjj
mmm_nnn_oooo -> oooo
how to handle this in T-SQL?
regards!
