I presume that you want to do paging of the recordset:
http://www.aspfaqs.com/webtech/062899-1.shtml
Record numbering is unrealistic and in most circumstances impossible to
maintain.
You are *always* better off constructing a query with appropriate filtering
that returns the exact data that you want or use the functionality above to
ensure paging of that data to reduce the data displayed at any one time.
Chris.
"dave" <an*******@discussions.microsoft.com> wrote in message
news:aa****************************@phx.gbl...
hi
Is it possible to write sql query to fetch records from
specific record number?
lets say i have one variable and it stores values such as
1,2,3 or so...
if variable contains, i want to fetch records from 1 to
20.
if it contains 2, then records should be from 21 to 40.
for 3, records would be 41 to 60...
what could be the sql for that?
i dont wannna fetch whole table and then filtering
through code..
any help would be appreciated...
cheers,
dave