Hello Kjarten, You're on the right track. Any whole number "mod 2" will be 0 for even numbers and 1 for odd. So, to select all the odd values from a table, use the SQL Query window and use the following in the where clause box:
YourField mod 2 = 0 or for odd, YourField mod 2 = 1 With a packed table (ie. no deleted records), you can use "rowid" for this. This allows you to query every other record starting at the beginning of a table (record 1) or record number 2. Regards, Warren Vick Europa Technologies Ltd. http://www.europa-tech.com -----Original Message----- From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]On Behalf Of Kjartan Greiff Selnes Sent: Friday, January 11, 2002 1:27 PM To: Mailingliste Mapinfo Subject: MI-L even number or not.. Hi folks. This has been an topic before but anyway: How do i select even (or odd) numbers in a coloumn. i know it's something about 'Mod' but i cant seem to get the syntax correct Kjartan. _______________________________________________________________________ List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MapInfo-L" in the message body. _______________________________________________________________________ List hosting provided by Directions Magazine | www.directionsmag.com | To unsubscribe, send e-mail to [EMAIL PROTECTED] and put "unsubscribe MapInfo-L" in the message body.
