recognize alpha's in varchar field of numeric characters
- From: md <mardahl2000@xxxxxxxxx>
- Date: Fri, 28 Mar 2008 08:07:56 -0700 (PDT)
I want to recognize alpha values buried in varchar fields.
5555X5555 = hit
5555555 = no hit
select * from table where to_number(field) is not null;
Doesn't work. Was counting on to_number to fail if it hit an alpha,
which it does, but the
query dies too. Any ideas? Can do with simple sql?
.
- Follow-Ups:
- Re: recognize alpha's in varchar field of numeric characters
- From: yossarian
- Re: recognize alpha's in varchar field of numeric characters
- Prev by Date: Re: Oracle Cerificates
- Next by Date: Re: recognize alpha's in varchar field of numeric characters
- Previous by thread: Oracle Cerificates
- Next by thread: Re: recognize alpha's in varchar field of numeric characters
- Index(es):
Relevant Pages
|
