Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: select only numeric value from varchar2 column
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:27:44 CDT