Re: Numeric Function

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

hth
connor

-- 
==============================
Connor McDonald

http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue..."