Received: from smtp-out1.bellatlantic.net (smtp-out1.bellatlantic.net [199.45.39.156]) by hub.org (8.9.1/8.9.1) with ESMTP id SAA08683 for ; Sat, 23 Jan 1999 18:05:52 -0500 (EST) (envelope-from daybee@bellatlantic.net) Received: from daveh (client-151-196-125-2.bellatlantic.net [151.196.125.2]) by smtp-out1.bellatlantic.net (8.9.1/8.9.1) with SMTP id SAA10820; Sat, 23 Jan 1999 18:05:40 -0500 (EST) Message-ID: <004f01be4724$f76d9020$027dc497@daveh> From: "David Hartwig" To: "Tim Perdue, The Des Moines City.net" , Subject: Re: [SQL] Select... RANGE? Date: Sat, 23 Jan 1999 18:06:09 -0500 MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.0810.800 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.0810.800 See DECLARE CURSOR, MOVE and FETCH. ----- Original Message ----- From: Tim Perdue, The Des Moines City.net To: Sent: Saturday, January 23, 1999 2:52 PM Subject: [SQL] Select... RANGE? >I'm not finding any sample code that allows you to select a range in a >result set. > >Let's say my query matches 500 records. I want it to return records 100-125. >I'm pretty sure I've seen this done, but I don't know where/how. > >Tim > >