Find the last position of an element in sql

Question

I am tring to find the last position of an element in a column in sql (oracle). If I have on a column the value 20-7-1-2-2 I need the position of the last - which is 9. Any ideas how I could find it?

A Google search turned up this answer http://stackoverflow.com/a/856832/50552 — Andomar, Aug 20 '14 at 07:26

score 1 · Accepted Answer · answered Aug 20 '14 at 07:25

1

try like this

select INSTR(columnname, '-', -1) from tablename

Fiddle

answered Aug 20 '14 at 07:25

Sathish

4,419
4
30
59

score 0 · Answer 2 · answered Aug 20 '14 at 07:32

0

    select instr('20-7-1-2-2', '-', -1, 1) from dual
-------------------------------------^

-1 means search from end of string

See the Oracle Instr reference.

answered Aug 20 '14 at 07:32

Lord Peter

3,433
2
33
33

Find the last position of an element in sql

2 Answers2