SQL: Get Next, Get Previous

G’Day

I am currently engaged in converting a system that uses a proprietary file format for storing data to a MS-SQL Server backend.

The current application has a feature whereby the user can move forwards and backwards through the records based upon a particular field (eg if you click on the Student Surname field [say it is currently SMITH ALISON] you will get the next record SMITH ANDREW], a SHIFT-CLICK will move you back a record). The Surname and First Name components are in two seperate fields.

How can you do this using a SQL Select statement?

Cheers
Rodney