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>
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