Re: select only numeric value from varchar2 column

From: Chris Colclough <chris.colclough_at_jhuapl.edu.nospam>
Date: Tue, 20 Jul 1999 10:43:54 -0400
Message-ID: <37948B2A.52DC5F3A@jhuapl.edu.nospam>

Correction to previous post. Please change translate(a, ....
to
translate(column, ....

Chris Colclough wrote:

> Try:
>
> select column
> from table
> where
> instr(
> translate(a,
> 'ABCDEFGHIJKLMNOPQRSTUVWXYZ','XXXXXXXXXXXXXXXXXXXXXXXXXX'),'X') = 0
> /
>
> 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 - 09:43:54 CDT