Re: Extract only numerical values for Oracle

Hello there!

Try this query:

select * from table_name where replace(translate(field_name,'1234567890',' '),' ') is null;

Dario

"Stielmond Ng" <lkng_at_ncs.com.sg> wrote in message news:3AF2527E.AFDEF761_at_ncs.com.sg...
> Hi,
>
> Could someone shed some light on the way where I could fire an SQL
> statement
> to retrieve records based on a column's data of a fixed size and also
> numeric?
> E.g.. a column named NUMBER contains records:
>
> 1234567
> 234a67
> 34b67
>
> I would like to retrieve only the record with '1234567'.
>
> Thanks very much,
> Stielmond NG
>
Received on Fri May 04 2001 - 11:04:38 CEST