Sql statement to find records from x to y

[serkan sendur]

Hi guys,
I want to select records from the database, i need to pass start index and end index, then the result set will include those records.
Let say my database table has 100 records, i want to get the records between 30-50. How can i do that?

[serkan sendur]

i found it at this address:

http://www.davidhayden.com/blog/dave/archive/2005/12/30/2652.aspx