Re: Extract only numerical values for Oracle

From: Domagoj Popic <domagoj_at_plusplus.hr>
Date: Fri, 4 May 2001 11:58:50 +0200
Message-ID: <9ctu9p$bq22$1@as121.tel.hr>

This is solution if the data consists only of alphanumerical characters:

select * from TABLE_NAME where upper(FIELD_NAME)=lower(FIELD_NAME)

Domagoj++

"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 - 04:58:50 CDT