Re: Find last occurance of character

From: NetComrade <netcomradeNSPAM_at_bookexchange.net>
Date: Thu, 02 Jun 2005 15:36:17 GMT
Message-ID: <429f2719.1239504546@localhost>

On Thu, 2 Jun 2005 11:12:44 +0100, Jeremy <newspostings_at_hazelweb.co.uk> wrote:

>In article <429e2e09.1175744687_at_localhost>, NetComrade says...
>> is there a way (using oracle functions) to find last occurance of
>> character w/o writing a recursive function?
>>
>> e.g. select XXXX('ooozo','o') from dual
>> would return 5
>>
>>
>
>SELECT INSTR('ooozo','o',-1) FROM dual;

Argh.. I can't believe I completely forgot built in functions have this capability.

Thanks

.......
We use Oracle 8.1.7.4 and 9.2.0.5 on Solaris 2.7 boxes remove NSPAM to email Received on Thu Jun 02 2005 - 10:36:17 CDT