Re: substr instr

Drat! Missed that one small detail :-(

Oh well... let's try to lose the InStr()s and SubStr()s altogether:

with demo as (select 'Start net counter : 203542, 201282' x from dual) select rtrim(rtrim(ltrim(x,'Start net counter :'),'0123456789 '),',') result from demo;

albeit with caveats:
a) the constant prefix should contain no other characters than those in LTrim's first parameter and definitely no digits b) the data may contain at most one number and no commas after the first comma
c) I'm not at all sure a couple of InStr()s and a SubStr() would be slower than three Trim()s (or alternatively a Replace() and two Trim()s, as Jaromir pointed out), but I have no V9i to test.

Cheers!
Flado

--
http://www.freelists.org/webpage/oracle-l