Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: Reg. SQL Operator..

Re: Reg. SQL Operator..

From: Ron Rogers <RROGERS_at_galottery.org>
Date: Tue, 21 Nov 2000 08:27:13 -0500
Message-Id: <10687.122603@fatcity.com>


Arul.
 you can use "SELECT empname FROM emp WHERE SUBSTR(empname,1,1) BETWEEN = 'A' and 'S';"
your output will be a list of employees with the first letter of their = name between A-S;
ROR m=AA=BF=AAm

>>> rakumar_at_mahindrabt.com 11/20/00 11:40PM >>>
hi,

I would like to know how to write a query to fetch a range of records?.

Say,for example. i have a table Emp with Empname ( a Varchar2 col.).

To fetch Employees whose names starts with A to S .

Output should be :

Arul
Binesh
..
..
Rajan
Sathish

Is there any operator like [A-S] ? as in Sybase... Received on Tue Nov 21 2000 - 07:27:13 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US