Do you mean something like this
SELECT MAX(DATE_INI) FROM SALE WHERE DATE_INI < :VDATE;

Ivan

----- Original Message -----
From: "Carlos Arguilar" <carlos_arguilar@...>
To: <firebird-support@yahoogroups.com>
Sent: Thursday, March 03, 2005 1:02 PM
Subject: [firebird-support] How to iterate through the records



Hello:
I would like know if exists a manner of iterate through the records
inside a stored procedure. For instance:
I created a sp with following statement:
.
SELECT DATE_INI FROM SALE WHERE DATE_INI = :VDATE;
.
Well, I need, next, retrieve the record prior to the record retrieve for
the select clause above.
How to do it?
Thanks for help.
Regards,
Carlos Arguilar