Re: Reg. SQL Operator..

can also use

select ename from emp where upper(substr(ename,1,1)) between 'A' and 'S'

-ajay

• Original Message ----- From: "Ura!" <ura_at_ymz.yaroslavl.ru> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Tuesday, November 21, 2000 1:01 AM Subject: Re: Reg. SQL Operator..

>
> Arul,
> ----------------------------------------
>
> Ak> hi,
>
> Ak> I would like to know how to write a query to fetch a range of
records?.
>
>
> Ak> Say,for example. i have a table Emp with Empname ( a Varchar2 col.).
>
>
> Ak> To fetch Employees whose names starts with A to S .
>
>
> Ak> Output should be :
>
>
> Ak> Arul
> Ak> Binesh
> Ak> ..
> Ak> ..
> Ak> Rajan
> Ak> Sathish
>
>
> Ak> Is there any operator like [A-S] ? as in Sybase...
> 1) select empname from emp where empname like 'A%' and empname like
> 'B%' ....
> 2) select ename from emp where substr(ename,1,1) in ('A','B',....)
>
> Ak> Thanks.
>
>
> Ak> Arul.
>
>
>
>
> ----------------------------------------
> ura_at_ymz.yaroslavl.ru
> Ura!
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: Ura!
> INET: ura_at_ymz.yaroslavl.ru
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
Received on Tue Nov 21 2000 - 09:44:30 CST