Reg. SQL Operator..

From: Arul kumar <rakumar_at_mahindrabt.com>
Date: Tue, 21 Nov 2000 10:20:44 +0530
Message-Id: <10686.122579@fatcity.com>

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

<!doctype html public "-//w3c//dtd html 4.0 transitional//en">
<html>

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

--------------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_at_mahindrabt.com
title:Software Engineer Received on Mon Nov 20 2000 - 22:50:44 CST