Re: Numeric value in VARCHAR?

create your own IsNumber function:
create or replace function IsNumber(p_charval in varchar2) return boolean is

   l_num number;
begin

   l_num := p_charval;
   return true;
exception when others then

   return false;
end IsNumber;

hth,
gert

-- 
reply address is altered to keep the spam down
remove the nospamplease part to reply...

Robert Whitaker <rswhitaker_at_ucdavis.edu> wrote in article
<64qjl4$98n$1_at_mark.ucdavis.edu>...


> Can anyone tell me of a way to interrogate a column that is a VARCHAR2


 datatype 


> to determine if the value can be converted to a number? Visual Basic has


 a nice 


> function IsNumber(arg). Can't something similar be done with SQL?


> 

> -RSW

> 

>