Re: select only number from varchar2

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?

Answered in the other forum where you posted the question.

In the future please don't multipost and/or crosspost.

Daniel Morgan Received on Sat Jan 04 2003 - 11:33:28 CST