Simple problem...

But I can't find an easy solution.

For 817 without rolling your own PL/SQL func... Is there a fast builtin way to do IS_A_NUMBER('STRING') or is_a_float() or is_an_integer()

i.e. given a string return true if the string represents a valid number or false. Or do most people trap an error from TO_NUMBER ?

T ... Received on Thu Feb 27 2003 - 09:37:03 CST