Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: select only number from varchar2
<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 SarwarReceived on Sun Jan 05 2003 - 10:30:50 CST