For odd numbers: WHERE (MOD(STREETNUM,2)) = 1 For even numbers: WHERE (MOD(STREETNUM,2)) = 0
Dennis McGrath ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of DAVID Sent: Monday, March 16, 2009 9:43 AM To: RBASE-L Mailing List Subject: [RBASE-L] - ODD AND EVEN NUMBERS CAN ANYONE TELL ME THE SYNTAX FOR FINDING ODD AND EVEN NUMBERS IN A WHERE CLAUSE ( PRINT report FROM STUDENT WHERE STREETNUM IS ODD) THANKS DAVID MILTENBERGER
