Travis-
Select * from TABLE Where COLUMN / 2 = Int(COLUMN / 2) 'evens
Select * from TABLE Where COLUMN / 2 <> Int(COLUMN / 2) 'odds
Tim Nuteson
Target Corporation
-----Original Message-----
From: Lathrop, Travis [mailto:[EMAIL PROTECTED]]
Sent: Friday, October 20, 2000 2:43 PM
To: '[EMAIL PROTECTED]'
Subject: MI-L
How would I type a SQL if I am looking to find all the odd/even integers in
a particular column?
Travis Lathrop
Intercarrier Service
913/762-4806
_______________________________________________________________________
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.