Re: Numeric string ??

Olivier BRUZEAUX wrote:
>
> I am looking for an sql command to test in my string is only numeric ??
> VARCHAR string [15]
>
> Olivier

If you are talking about plsql, then do it like this:

Function Is_Number(Buff varchar2) return integer is

    Dummy Number := 0;
begin

    Dummy := Buff;
    return(0);
exception

    when invalid_number then

        return(1);
    when others then

        return(2)
end;

If you pass a numeric string to the function it will return 0 if the value was truely numeric, if it is an invalid number it will return 1. If there was some other error it will return 2. Received on Wed Dec 08 1999 - 07:35:17 CST