RE: Reg. SQL Operator..

it is easy with a simple where clause

        where substr(Empname,1,1) between 'A' and 'S'

done deal.

-----Original Message-----

From:	Arul kumar [SMTP:rakumar_at_mahindrabt.com]
Sent:	Monday, November 20, 2000 11:40 PM
To:	Multiple recipients of list ORACLE-L
Subject:	Reg. SQL Operator..

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...

Thanks.

Arul.
 << File: ATT00005.html >> << File: rakumar.vcf >> Received on Tue Nov 21 2000 - 07:13:31 CST