Question? Numeric Functions

Is there any good numeric function available that can check to see if a varchar2 or char column contains a pure numeric number? Preferably, a function that can be checked by an If Statement without generating a PLS-00382 error. It would only execute the preceding Block if statements and no execute upon failure.

As an example a column containing the values '102-1' would generate an error in using the TO_NUMBER() function, but a column containing the values '102.1' would not.

Any help would be greatly appreciated.

Ray- Received on Tue Apr 17 2001 - 21:57:15 CDT