Re: recognize alpha's in varchar field of numeric characters
- From: yossarian <yossarian99@xxxxxxxxxxxxx>
- Date: Fri, 28 Mar 2008 16:11:01 +0100
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.
.
- Follow-Ups:
- References:
- Prev by Date: recognize alpha's in varchar field of numeric characters
- Next by Date: Oracle Cerificates
- Previous by thread: recognize alpha's in varchar field of numeric characters
- Next by thread: Re: recognize alpha's in varchar field of numeric characters
- Index(es):
