Re: REGEXP_like

On Apr 28, 5:57 am, Mladen Gogala <mgogala.SPAM_ME...._at_verizon.net> wrote:
> On Fri, 27 Apr 2007 10:09:26 -0700, Vladimir M. Zakharychev wrote:
> > select id from my_table where regexp_like(id,'0[0-9]$')
>
> > should do the trick.
>
> Even better: regexp_like(id,'0\d$')
>
> That is an old trick learned by an extensive use of pathologically
> eclectic rubbish lister.
>
> --http://www.mladen-gogala.com

Indeed, but won't work in 10.1, only in 10.2 and later. That's why I chose the universally accepted bracketed expression - the OP didn't mention Oracle version.

Regards,

   Vladimir M. Zakharychev
   N-Networks, makers of Dynamic PSP(tm)    http://www.dynamicpsp.com Received on Sat Apr 28 2007 - 00:07:01 CDT