Hello.

In my database I want to find all the records where odd numbers.
How can I do this with SQL.

TIA
Dieter Nagy

"Dieter Nagy" <Dieter.Nagy@tele2.at> wrote in message
news:BF51FF9D-38A1-47EA-BF94-92457A8DA905@news.elevatesoft.com...
> Hello.
>
> In my database I want to find all the records where odd numbers.
> How can I do this with SQL.
>

If what you want is to select records where a certain field is odd, then the
following will do it

select * from table where field mod 2 = 1

if what you want is every other record, it gets a bit more complicated.

Robert

"Robert" <ngsemail2005withoutthis@yahoo.com.ar> wrote:


Thanks Robert.

Dieter




"Dieter Nagy" <Dieter.Nagy@tele2.at> wrote in message
news:BF51FF9D-38A1-47EA-BF94-92457A8DA905@news.elevatesoft.com...
> Hello.
>
> In my database I want to find all the records where odd numbers.
> How can I do this with SQL.
>

If what you want is to select records where a certain field is odd, then the
following will do it

select * from table where field mod 2 = 1

if what you want is every other record, it gets a bit more complicated.

Robert