Re: select only number from varchar2
From: DA Morgan <damorgan_at_exesolutions.com>
Date: Sat, 04 Jan 2003 09:17:49 -0800
Message-ID: <3E17173D.559A8AB3_at_exesolutions.com>
Date: Sat, 04 Jan 2003 09:17:49 -0800
Message-ID: <3E17173D.559A8AB3_at_exesolutions.com>
rx_at_wo.cz wrote:
> 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?
SELECT TRANSLATE(UPPER(varchar2column), '1ABCDEFGHIJKLMNOPQRSTUVWXYZ',
'1')
FROM ...
Daniel Morgan
Received on Sat Jan 04 2003 - 18:17:49 CET