Re: select only numeric value from varchar2 column

From: Chris Colclough <chris.colclough_at_jhuapl.edu.nospam>
Date: Tue, 20 Jul 1999 11:10:43 -0400
Message-ID: <37949173.7268CFFB@jhuapl.edu.nospam>

A variation on the theme:

select column
from table
where translate (column, '0123456789','**********') = rpad('*', length(a), '*')
/

Bruno Decraene wrote:

> I have a table toto with varchar column col1
>
> col1 contains alphanumeric values and numeric values and i want to
> select only the numeric values
>
> How can i do this
>
> Thank you
>
> ansewer to me to rchennaa_at_atos-group.com
>
> Rach
Received on Tue Jul 20 1999 - 10:10:43 CDT