select only number from varchar2

From: <rx_at_wo.cz>
Date: Sat, 4 Jan 2003 16:05:52 +0100
Message-ID: <av6t8k$cfcl9$1_at_ID-123390.news.dfncis.de>



[Quoted] for example I have this records in varchar2 column:

A123D
BLA124XX
125
lkl567836785366AW
2Q

and now I need select only number for spool :

123
124
125
567836785366
2

Have you any idea? Received on Sat Jan 04 2003 - 16:05:52 CET

Original text of this message