SQL 2000 - T-SQL

Can anyone shed any light on this?

I need a resultset returned from SQL Server from a Customer table. The
table has an Identity column as a Primary Key - Eg. CustomerID

The resultset will reflect various searches. Eg. By Surname, By
Surname & PostCode

I'm being passed 2 extra variables: PageNumber and RowsPerPage

Thus, if the initial resultset of a search on 'Smith%' brought back
100 rows and PageNumber was 5 and RowsPerPage was 10, then I would
return rows 51 to 60.

The Order By clause would be on Surname, Forename.

Can this be written in SQL without resorting to either Cursors or
Temporary Tables?

Thanks for your help.

You can read messages from the OLEDB_DEV archive, unsubscribe from OLEDB_DEV,
or subscribe to other DevelopMentor lists at http://discuss.develop.com.