Re: REGEXP_like

On Apr 27, 7:53 pm, cptkirkh <k..._at_scic.com> wrote:
> I have to write a SQL query that looks for the last two digits of an
> ID and only includes them in the query. For example
>
> select ID from my_table where regexp_like(id, '00$') between
> regexp_like(id,'09$')
>
> I want only the people who have an id that ends in 00 to 09. Can I do
> this or what is the best way to do this? Thanks for your help.

select id from my_table where regexp_like(id,'0[0-9]$')

should do the trick.

Regards,

   Vladimir M. Zakharychev
   N-Networks, makers of Dynamic PSP(tm)    http://www.dynamicpsp.com Received on Fri Apr 27 2007 - 12:09:26 CDT