Or you could use the Mod function
Select * from TABLE Where COLUMN mod 2 = 0 'evens
Select * from TABLE Where COLUMN mod 2 <> 0 'odds
HTH,
Chris Perry
Corporate Systems CoOrdinator
Parks Victoria
Melbourne, Australia
Ph: 61 3 9816 6800
Fax: 61 3 9816 7222
[EMAIL PROTECTED]
-----Original Message-----
From: Tim.Nuteson (Exchange) [mailto:[EMAIL PROTECTED]]
Sent: Saturday, 21 October 2000 6:24
To: 'Lathrop, Travis'
Cc: '[EMAIL PROTECTED]'
Subject: RE: MI-L
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.
**********************************************************************
This message and any files transmitted with it are intended only for
the addressee. This message may contain confidential or privileged
information. If you are not the addressee of this message you must not
read, copy, distribute this information or take an action in reliance on it.
If you have received this message in error you are requested to
immediately contact the sender or Parks Victoria at
[EMAIL PROTECTED] and delete the original and any copies
of this message and any files transmitted with it. The views expressed
in this message are those of the individual sender, except where the
sender has the authority and specifically states them to be the views
of Parks Victoria. Parks Victoria accepts no liability for any damage
caused in the transmission, receipt or opening of this message and any
files transmitted with it.
**********************************************************************
_______________________________________________________________________
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.
