Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Numeric Function

Re: Numeric Function

From: Richard Kuhler <noone_at_nowhere.com>
Date: Wed, 07 Nov 2001 23:35:23 GMT
Message-ID: <%yjG7.20674$D5.8286434@typhoon.san.rr.com> 






Connor McDonald wrote:


> 

> NeedaHoliday wrote:

> >

> > Is there a function or method to search a string character and find

> > only numeric values?

> >

> > Thanks

> 

> where

>   replace(

>     translate(col,'0123456789','9999999999')

>          '9',null) is null

> 

> or thereabouts

> 




or more efficiently....



where translate(col, ' 0123456789', ' ') is null




Richard
Received on Wed Nov 07 2001 - 17:35:23 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US