Home » SQL & PL/SQL » SQL & PL/SQL » instr()
instr() [message #843] Thu, 07 March 2002 12:14 Go to next message
Gideon Clewlow
Messages: 2
Registered: March 2002
Junior Member
Hello all,

Does anyone know how to return the alphas at the end of a string. I was thinking of using instr inside a substr but don't know how to tell it that the start position is a character and not a number. This has to work with varying sized strings.

...eg...

For 00144587blahblahblah return blahblahblah
for 0015478512255xxxxxxxx return xxxxxxxx

Cheers
Re: instr() [message #848 is a reply to message #843] Fri, 08 March 2002 04:36 Go to previous message
Suresh Vemulapalli
Messages: 624
Registered: August 2000
Senior Member
select substr('00144587blahblahblah',instr(translate('00144587blahblahblah','1234567890','1111111111'),'1',-1)+1)
from dual;
Previous Topic: Changing database
Next Topic: Return lower case fields
Goto Forum:
  


Current Time: Wed Oct 27 05:15:22 CDT 2021