| instr() [message #843] |
Thu, 07 March 2002 12:14  |
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  |
Suresh Vemulapalli
Messages: 624
Registered: August 2000
|
Senior Member |
|
|
select substr('00144587blahblahblah',instr(translate('00144587blahblahblah','1234567890','1111111111'),'1',-1)+1)
from dual;
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
