Re: select only number from varchar2

From: Rauf Sarwar <rs_arwar_at_hotmail.com>
Date: 5 Jan 2003 08:30:50 -0800
Message-ID: <92eeeff0.0301050830.447460be@posting.google.com>

<rx_at_wo.cz> wrote in message news:<av6tdv$clm6a$1_at_ID-123390.news.dfncis.de>...
> 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?

Look up usage of TRANSLATE(char, from, to). Here is a quick short example,

SQL> SELECT TRANSLATE('AB123CD', '123ABCD', '123') FROM DUAL; TRA

---
123

/Rauf Sarwar

Received on Sun Jan 05 2003 - 10:30:50 CST