Re: REGEXP_like

On Apr 29, 5:52 pm, Mladen Gogala <mgogala.SPAM_ME...._at_verizon.net> wrote:
> On Fri, 27 Apr 2007 22:07:01 -0700, Vladimir M. Zakharychev wrote:
> > Indeed, but won't work in 10.1, only in 10.2 and later.
>
> I didn't know that, thanks! Unfortunately, I don't have any 10.1
> databases to try, all I have are 10.2. All we need now is for Oracle
> to take over extproc_perl and implement it as a standard database
> language.
>
> --http://www.mladen-gogala.com

Thanks for the help. By looking at the expression of select id from my_table where regexp_like(id,'0[0-9]$') It works but what if you have to accoutn for numbers from 00-99. This looks like it only counts from 00-09. Can you do the following?

select id from my_table where (regexp_like(id,' [00-09]$') can that then be edited to be changed in the form of [xx - yy]$ where I can change the values xx or yy to any value I wish to limit the query by the last two digits? Received on Mon Apr 30 2007 - 16:52:12 CDT