Re: Range select

From: Michael Serbanescu <mserban_at_postoffice.worldnet.att.net>
Date: 1997/10/23
Message-ID: <344ef23d.7191222_at_netnews.worldnet.att.net>#1/1

If you insist on using LIKE (although I am not sure I understand the bit about 'like' being hardcoded), try this (very awkward !):

SELECT ...
 WHERE ((...LIKE 2%) OR (...LIKE 3%) OR (...LIKE 4%) OR (...LIKE 5%)); Hope this helps.

Michael Serbanescu

---

[Quoted] On Wed, 22 Oct 1997 16:56:09 +0200, "Pertti Kuusisto" <kuusisto_at_dalnet.se> 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
>
>
>
Received on Thu Oct 23 1997 - 00:00:00 CEST