Re: sql - first 10 records

another way is to select into a temp table. these will always be contiguos(?) so unless you delete from it there wont be any gaps you can then use rowids. select * from table1 into temp table2; select * from table2 where rowid<=10;-- Mike Aubury