Hi.

where ( field / 2 ) * 2 = field.

(Don't do this for large tables. This is hell for the query optimizer. Use a
precomputed column instead and have a combined index on that field and the
primary key.)

Regards,
Steffen

> -----Original Message-----
> From: maurizio [mailto:maurizio@...]
> Sent: Wednesday, March 16, 2005 2:54 PM
> To: Firebird-Java@yahoogroups.com
> Subject: [Firebird-Java] Help: odd and even
>
>
>
> Hi,
> It's possible to select odd or even number in a INTEGER field
> by query?
> thak's
>
> --
> Maurizio Poli
>
> Etarom Multimedia Project
> Via del Tiglio 45
> 56012 Calcinaia (PI)
> Tel & Fax 0587-59108
> cell 340 8398772
> E-mail maurizio@...
>
> ****************************************
> Qualora questo messaggio fosse da Voi ricevuto per errore
> vogliate cortesemente darcene notizia a mezzo telefax o
> e-mail e distruggere il messaggio ricevuto erroneamente.
> Quanto precede ai fini del rispetto del D.Lgs 196/03 sulla
> tutela dei dati personali.
> ****************************************
>
>
>
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
>

[Non-text portions of this message have been removed]