Another Substr / Instr question 1

[cheesyman5k]

hello all,

can you help me create the correct substring or intstring statement to return everything after the second to last underscore of a column value?

for example:

column value = 'cheesy_man_5000'
return value should be 'man_5000'

column value = 'tek_tips_is_the_best'
return value should be 'the_best'

I thank you all in advance!

cheesy

 

[Dagon]

SELECT substr('tek_tips_is_the_best', instr('tek_tips_is_the_best', '_',-1, 2)+1) from dual

 

[cheesyman5k]

Thanks again Dagon!

I hope to someday reciprocate.

cheese