What you are Requesting is SQl Paging, try this select top 10 * employees from employees where NOT employee_id IN (select top 10 employee_id from employee) And look at this http://www.petefreitag.com/item/59.cfm[^] or http://www.sqlteam.com/article/whats-after-top[^] And as you can see the above Example and links, requires you to have a Primary key for your table Thanks Hope it helps
Vuyiswa Maseko, Sorrow is Better than Laughter, it may Sadden your Face, but It sharpens your Understanding VB.NET/SQL7/2000/2005 http://vuyiswamb.007ihost.com http://Ecadre.007ihost.com vuyiswam@tshwane.gov.za