From: Christoph Boget Date: August 31 2010 6:25pm Subject: Re: FW: Even or Odds numbers List-Archive: http://lists.mysql.com/mysql/222763 Message-Id: MIME-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable >> where X is your number (or column name). =A0If 0, it's even if >> 1 it's odd. > I think you mean, if it is non-zero, then it is odd. If you're MODding using 2 as the second argument, it's always going to be 0 or 1. 2 either divides in to the number evenly, having a remainder of 0, or it'll have a remainder of 1. The former indicates the number is even, the latter odd. thnx, Christoph