Message-Id: <10686.122579@fatcity.com> From: Arul kumar Date: Tue, 21 Nov 2000 10:20:44 +0530 Subject: Reg. SQL Operator.. This is a multi-part message in MIME format. --------------0F5CFFD3629D20C58C32FFAE Content-Type: multipart/alternative; boundary="------------40D6FE152026A96AEFA46B02" --------------40D6FE152026A96AEFA46B02 Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit 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. --------------40D6FE152026A96AEFA46B02 Content-Type: text/html; charset=us-ascii Content-Transfer-Encoding: 7bit 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. --------------40D6FE152026A96AEFA46B02-- --------------0F5CFFD3629D20C58C32FFAE Content-Type: text/x-vcard; charset=us-ascii; name="rakumar.vcf" Content-Transfer-Encoding: 7bit Content-Description: Card for Arul kumar Content-Disposition: attachment; filename="rakumar.vcf" begin:vcard n:; tel;work:542 43 01 Ext- 3042 x-mozilla-html:FALSE org:MBT, adr:;;Sharda Centre,;Pune;Maharashtra;411 004;INDIA. version:2.1 email;internet:rakumar@mahindrabt.com title:Software Engineer