Hoping that the predicates are evaluated in a certain order (or indeed
forcing it with an ORDERED_PREDICATES hint) just to ensure that all
text is "numeric" is a flawed approach IMHO. If you are writing a
IS_NUMBER function, this surely should handle the obvious exceptions -
in this alpha strings. For example, my IS_NUMBER function returns TRUE
or FALSE for PL/SQL or 0 or 1 for SQL. It doesn't fail. Which is why I
return to my original post and request that we see the function.
Regards
Adrian
Received on Mon Oct 27 2003 - 03:56:09 CST
