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_at_as121.tel.hr>
Date: Fri, 4 May 2001 11:58:50 +0200
Message-ID: <9ctu9p$bq22$1_at_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 - 11:58:50 CEST