Finding even and odd numbers

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Marius - 07 Jul 2008 08:34 GMT

Hi!

I want to search for even and odd numbers using a SELECT query. I thougth
there was a MOD function, but cannot find information or examples with it. I
got a SQL Server 2000.

Thanks all,

Signature

Marius

Reply to this Message

Uri Dimant - 07 Jul 2008 08:44 GMT

Hi
SELECT IDENTITY(INT) "n" INTO Numbers
FROM sysobjects s1
CROSS JOIN sysobjects s2
GO

SELECT * ,CASE n%2 WHEN 0 THEN 'even' ELSE 'odd' END
FROM Numbers

> Hi!
>
[quoted text clipped - 4 lines]
>
> Thanks all,

Reply to this Message

Marius - 07 Jul 2008 10:53 GMT

How can I modify this sentence to only give me the rows where a certain
column has a even number?

SELECT * ,CASE n%2 WHEN 0 THEN 'even' ELSE 'odd' END
FROM Numbers

Signature

Marius

> Hi
> SELECT IDENTITY(INT) "n" INTO Numbers
[quoted text clipped - 13 lines]
> >
> > Thanks all,

Reply to this Message

Uri Dimant - 07 Jul 2008 10:59 GMT

Add WHERE n%2=0

> How can I modify this sentence to only give me the rows where a certain
> column has a even number?
[quoted text clipped - 21 lines]
>> >
>> > Thanks all,

Reply to this Message