RE: ODD vs EVEN in select

}---------- }From: May, James }Sent: Thursday, April 17, 1997 9:22 AM }To: 'mmi@fox.nstn.ca' }Subject: RE: ODD vs EVEN in select } }To get even values: } }select <integer field> from <table> }where mod(<integer field>,2) = 0 } }To get odd values: } }select <integer field> from <table> }where mod(<integer field>,2) = 1 } } }James May }Sr. Database Analyst, }Agency for Health Care Administration, Florida }voice 904.922.9137 }email = mayj@fdhc.state.fl.us } } }---------- }From: Peter Procenko[SMTP:mmi@fox.nstn.ca] }Sent: Wednesday, April 16, 1997 11:31 AM }To: informix-list@rmy.emory.edu }Subject: ODD vs EVEN in select } }What is the easiest way to select only ODD or EVEN from a int field in a }select statement, via SQL ? } }Any help would be appreciated } }