Specific Row in a table

[elbimbo]

Im using SQL 7.0. I have 1 table with 6,000 records. How can I go to record 101 (i mean row 101 of my table) using a sql statement. Does anybody?
thanks in advance

[axion_sa]

SELECT TOP 1 * FROM Table WHERE FieldA NOT IN (SELECT TOP 100 FieldA FROM Table)

[Memnoch1207]

if there is a specific identifier for that record (such as a unique record number or something) then you can do

SELECT * FROM tablename WHERE recordnumber = " & txtRecordNumber.Text & "

this really depends on how you specify getting the recordnumber, whether it will be hard coded or there will be something like a textbox that a user can enter a recordnumber into.