Re: recognize alpha's in varchar field of numeric characters
From: md <mardahl2000_at_yahoo.com>
Date: Fri, 28 Mar 2008 08:46:36 -0700 (PDT)
Message-ID: <8aaab282-3465-4715-a222-01d957d36789@e39g2000hsf.googlegroups.com>
Date: Fri, 28 Mar 2008 08:46:36 -0700 (PDT)
Message-ID: <8aaab282-3465-4715-a222-01d957d36789@e39g2000hsf.googlegroups.com>
On Mar 28, 10:11 am, yossarian <yossaria..._at_operamail.com> wrote:
> md wrote:
> > I want to recognize alpha values buried in varchar fields.
>
> > 5555X5555 = hit
> > 5555555 = no hit
>
> This is a job for REGEXP_LIKE (if you are on 10g).
>
> Y.
regexp_substr(ra.industcode, '\D') is not null;
Thank you. Just happened upon it. Received on Fri Mar 28 2008 - 10:46:36 CDT