Re: recognize alpha's in varchar field of numeric characters

From: yossarian <yossarian99_at_operamail.com>
Date: Fri, 28 Mar 2008 16:11:01 +0100
Message-ID: <47ed0a86$0$16037$5fc30a8@news.tiscali.it>


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. Received on Fri Mar 28 2008 - 10:11:01 CDT

Original text of this message