Operator Link
- From: "ecaforum" <ecaforum@xxxxxxxxxxxxxxxxxx>
- To: <BSpears@xxxxxxxxxxxxxxxxx>, <mstrickland@xxxxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Sun, 17 Oct 2004 07:10:07 -0200
Friends :
I need to identify in a column if the 3 first characters are about datatye
number.
Is there another easy way to do it ?
I used the follow instruction :
where ascii(substr(columname,1,1)) between 47 and 57 and
ascii(substr(columname,2,1)) between 47 and 57 and
ascii(substr(columname,3,1)) between 47 and 57
Regards
Eriovaldo
--
//www.freelists.org/webpage/oracle-l
Other related posts:
