Checking for Numeric Values

I am working with data that sometimes is entirely numeric, sometimes alphanumeric (300,350A,400F, for example).

Is there a way to imitate the IsNumeric function in MS Basic, which returns a Yes/No depending on whether the value can be converted to a number?

TO_NUMBER(350A) yields ORA-01722: invalid number, and the program stops.

Thanks very much for your time and help.

Steven Moyano
Northwestern University, Evanston, IL. USA stevem_at_nwu.edu Received on Wed Mar 19 1997 - 00:00:00 CST