Kjartan,
I haven't checked this but the syntax should be:-
Even numbers
SELECT * FROM <TABNAME> WHERE <COLNAME> MOD 2 = 0
Odd numbers
SELECT * FROM <TABNAME> WHERE <COLNAME> MOD 2 = 1
These statements will only work with columns containing integers.
Keith
-----Original Message-----
From: Kjartan Greiff Selnes [mailto:[EMAIL PROTECTED]]
Sent: 11 January 2002 13:27
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.
This email and any attached files are confidential and copyright protected.
If you are not the addressee, any dissemination of this communication is
strictly prohibited. Unless otherwise expressly agreed in writing, nothing
stated in this communication shall be legally binding.
_______________________________________________________________________
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.
