How to get the ascii code for the first character in a strin
Posted: Mon Mar 13, 2006 3:20 am
Hello,
I need to check if a column data is numeric or character.
the data I get can only come in 2 ways for that column number or varchar2 ( the datatype of the column is ofcourse varchar2 )
I thought I'll just check for the ascii range of the first character ( If it is not between Ascii(48) and Ascii(57)) then it is a character
Anyway that is what I'm trying to do but, I just can't find a way to simply get the ascii code for the first character.
Any suggestions or clarifications will be appreciated.
I need to check if a column data is numeric or character.
the data I get can only come in 2 ways for that column number or varchar2 ( the datatype of the column is ofcourse varchar2 )
I thought I'll just check for the ascii range of the first character ( If it is not between Ascii(48) and Ascii(57)) then it is a character
Anyway that is what I'm trying to do but, I just can't find a way to simply get the ascii code for the first character.
Any suggestions or clarifications will be appreciated.