Finding last index of a string in Oracle

Question

I need to find the last index of a string (e.g. "-") within another string (e.g. "JD-EQ-0001" in Oracle (version 8i).

Is there a way to get the INSTR function to do this or is there another function?

Thanks James

Answer 1

Use -1 as the start position:

INSTR("JD-EQ-0001", "-", -1)