Re: ODD vs EVEN in select
>From: "Mark D. Stock" <marks@west.co.za>
>X-Informix-List-Id: <news.36705>
>Peter Procenko wrote:
>> What is the easiest way to select only ODD or EVEN from a int field in a
>> select statement, via SQL ?
>For EVEN numbers:
> SELECT *
> FROM tables
> WHERE int_col/2 = ROUND(int_col/2)>[...]
That's a long-winded way of writing:
SELECT *
FROM Tables
WHERE MOD(int_col, 2) = 0; -- Or 1
Yours,
Jonathan Leffler (johnl@informix.com) #include <witticism.h>