Hi Mike, You could use the mod function
eg select * from mytable where myfield mod 10 = 0 Cheers Martin ================================== Martin Roundill GIS Manager Waitakere City Council Private Bag 93109 Henderson Waitakere City New Zealand -----Original Message----- From: Mike Stein [mailto:[EMAIL PROTECTED]] Sent: Tuesday, 19 March 2002 20:47 To: [EMAIL PROTECTED] Subject: MI-L RE: SQL Hi all, I am trying to select a number of records from a field within my table which represent kilometre points along a route. These records range from 0 - 430. I would like to select every tenth record i.e. 0; 10; 20 etc, so that I can limit the visual clutter on screen. If anyone can help it would be most appreciated. Mike Stein GIS Project Assistant RSK/ENSR Ltd. Tel: +44 (0)1928 726006 Fax: +44 (0)1928 725633 mailto:[EMAIL PROTECTED] http://www.rsk.co.uk --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED] --------------------------------------------------------------------- List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
