> Of course, I have a single row. However, if the row, for example,
> retrieved : 2/28/2004. How to get the record prior to this in the table.
> This record isn't 2/27/2004 needs. Do you understand?

Yes, I understand. But do you. What is "the row prior to the
selected row"?

A row ONLY exists in a resultset. In a table, there's no order
of rows. What defines " a prior row "?

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL
Server
Upscene Productions
http://www.upscene.com