Re: Reg. SQL Operator..

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