OWA_PATTERN should do the job in that version, although it may not be installed and *will* have performance issues for large amounts of data. Niall On 7/29/09, Rich Jesse <rjoralist@xxxxxxxxxxxxxxxxxxxxx> wrote: > > > I think this should do nicely > > > > select regexp_replace('Start net counter : 203542, 201282','^.+: > > *([0-9]+),.*$','\1') > > from dual; > > > > Cheers, > > Flado > > But not in v9 that the OP's using... > > Rich > > -- > //www.freelists.org/webpage/oracle-l > > > -- Niall Litchfield Oracle DBA http://www.orawin.info