I am not clear what you want ..
Extract second char and
and use any number function to find it is number or not
If not number it will error out
select abs(itmid) from ccs_orders where rownum < 2
ERROR at line 1:
ORA-01722: invalid number
If it is number
SQL> select abs(acweek) from ccs_orders where rownum < 2;
Well to clarify things a bit, I won't be translating anything. I'm just trying to select data where the second position is alphabetical(i.e. a-z) so is there a way I can specify that without actually typing out all the letters in the alphabet?
I know I could do it with something like .. SUBTR(column-name,2,1) in 'ABCDEFGHIJKLMNOPQRSTUVWXYZ' but I'm assuming there some decent class function or something I could use?