But how would you get the 2nd 100 (101 - 200) and the 3rd 100 (301 to 400) without writing a subroutine to do it?
Regards Adrian Halid Senior Analyst/Programmer IT Vision Australia Pty Ltd (ABN: 34 309 336 904) PO Box 881, Canning Bridge WA 6153 Level 3, Kirin Centre, 15 Ogilvie Road, Applecross, WA, 6153 P: (08) 9315 7000 F: (08) 9315 7088 E: adrian.ha...@itvision.com.au W: http://www.itvision.com.au ___________________________________________________________ NOTICE : This e-mail and any attachments are intended for the addressee(s) only and may contain confidential or privileged material. Any unauthorised review, use, alteration, disclosure or distribution of this e-mail (including any attachments) by an unintended recipient is prohibited. If you are not the intended recipient please contact the sender as soon as possible by return e-mail and then delete both messages. ___________________________________________________________ -----Original Message----- From: u2-users-boun...@listserver.u2ug.org [mailto:u2-users-boun...@listserver.u2ug.org] On Behalf Of fft2...@aol.com Sent: Friday, 19 February 2010 4:55 AM To: u2-users@listserver.u2ug.org Subject: Re: [U2] TOP/LIMIT Equivalent? In a message dated 2/18/2010 10:27:46 AM Pacific Standard Time, cla...@hme.com writes: > You can sort first and then SAMPLE, too.>> Caryl has the idea here if you really want the "Last" 100. You can Sort BY-DSND which means "by descending" so if you want the last alphabetically or the last by ID or the last by some other field you can sort on that and then Sample 100 ? I've NEVER tried this. Does it work? If that doesn't work you can EXECUTE a sort by dsnd and then simply write a brief BASIC routine to pull off the "first" 100 of that list and output it! Will "Where There's a Way there's a Will... or something" Johnson _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users _______________________________________________ U2-Users mailing list U2-Users@listserver.u2ug.org http://listserver.u2ug.org/mailman/listinfo/u2-users