Try this:
Select *
From YourTable
Where YourColumn Mod 2 = 0
Into Even
Select *
From YourTable
Where YourColumn Mod 2 = 1
Into Odd
Serge
QA dept.
GeoCom TMS inc.
-----Original Message-----
From: David Reid
[mailto:[EMAIL PROTECTED]] <mailto:[mailto:[EMAIL PROTECTED]]>
Sent: Monday, September 04, 2000 7:17 PM
To: MapInfo-L
Subject: MI - Find odd or even
numbers in a column
Using "Select" how would I go about
selecting odd or even numbers in a
column? I thought I had figured out the
syntax but it didn't work.
Thanks list,
Dave
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail
to [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]> and put
"unsubscribe MAPINFO-L" in the message body,
or contact [EMAIL PROTECTED] <mailto:[EMAIL PROTECTED]>
----------------------------------------------------------------------
To unsubscribe from this list, send e-mail to [EMAIL PROTECTED] and put
"unsubscribe MAPINFO-L" in the message body, or contact [EMAIL PROTECTED]