Re: recognize alpha's in varchar field of numeric characters
Date: Fri, 28 Mar 2008 08:46:36 -0700 (PDT)
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).
regexp_substr(ra.industcode, '\D') is not null;
Thank you. Just happened upon it. Received on Fri Mar 28 2008 - 10:46:36 CDT