Re: Numeric value in VARCHAR?

Check out my web site
http://members.aol.com/jomarlen
on my Oracle Utilities page you'll
find PL/SQL libraries which include
is_number();

John

>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
>
>
>
>
Received on Wed Nov 19 1997 - 00:00:00 CET