substr and or instr 1

[cheesyman5k]

hello all,

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

for example:

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

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

I thank you all in advance!

cheesy

 

[Dagon]

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

 

[cheesyman5k]

Thanks so much Dagon, that did the trick!

cheesy