Re: to_number from a varchar field.

This code is slight variation of the is_number function in Feurstein's PLSQL Programming:

FUNCTION Is_Number (literal_in IN VARCHAR2)   RETURN PLS_INTEGER
IS
  val NUMBER;
BEGIN
    val := TO_NUMBER(literal_in);
   RETURN 1;
EXCEPTION
   WHEN OTHERS THEN RETURN 0;
END Is_Number;

Bye,
Flavio Received on Tue Feb 11 2003 - 16:14:13 CST