Originally posted by padders
LOL. Good call.
Actually not so good. I just realised I've made a stupid mistake with
Code:
v_str BETWEEN '0' AND '9'
since this will be false for any string beginning with '9' and followed by anything else. Since this is not what the original poster was looking for and since the character following "9" in any ASCII-based characterset is ":", my above suggestion should be rewritten into:
Code:
v_str >= '0' AND v_str < ':'
But then again, after reading this code only the most geekish of all the geeks will know what this code is all about, so I'd step back and vote for DaPi's suggestion (never mind the minor performance penalty) of using
SUBSTR (v_str, 1, 1) BETWEEN '0' AND '9'