Re: Range select

Pertti Kuusisto wrote:
>
> Dear colleauge,
>
> In some other db-systems it is posible to write a query like this:
>
> select .... where ... like '[2-5]%'
>
> that is to select a range with the 'like' keyword. Are there a way of doing
> that in oracle? (I know the 'between' keyword but that is not a solution
> because in my
> problem the 'like' is hardcoded.)
>
> Sincerely,
>
> Pertti Kuusisto

You can achive the above sql in Oracle using TRANSLATE function.

SELECT ....... WHERE
[Quoted]  TRANSLATE(column, '12345', '99999') like '%9%'

Hope this helps

AMARENDRA

-- 
******************************************************************************
AMARENDRA B NETTEM			5039 N E River Road, Apt. 1A
Certified Oracle DBA			NORRIDGE, IL 60656
Whittman-Hart Inc., 
311 South Wacker Drive, Suite 3500
Chicago, IL 60606.  

Ph.No. (708) 583 9870 (H)  
       (312) 913 6758 (W)  

 E-mail:nettama_at_charlie.cns.iit.edu,
        anettem_at_whittman-hart.com

Homepage: http://www.iit.edu/~nettama

****************************************************************************
Opinions are mine and do not necessarily reflect those of Whittman-hart
Inc.