I don't think there's a easy SELECT-SQL statement that will give you what you want because SELECT-SQL is set based, not record based.

Why not work with LOCATE, SKIP -1 and SKIP +2?

>Here is an interesting question. Is it possible to construct a sql-select statement that will return 3 adjacent records with the wanted keyfield in the middle? That is, a specified record WHERE keyfield = lnVal plus the record before and the record after. The 2 boundary records would be for the purpose of identifying the previous and next records for navigation purposes.
>
>Any thoughts?