Post reply

Odd or even numbers

  • March 23, 2006 at 8:55 am

    #111495

    Hi there,

    I am trying to use SQL to determine whether a value field is an odd or even number. I tried the following:

    Case

  • March 23, 2006 at 9:02 am

    #628378

    You can take the value and MOD by 2.

    select x.i, case x.i % 2 when 0 then 'even' when 1 then 'odd' end

    from

         ( select 1 as i union all

     select 2 union all

     select 3 union all

     select 4 union all

     select 5

         )  x

    i               

    ----------- ----

    1           odd

    2           even

    3           odd

    4           even

    5           odd

    (5 row(s) affected)

    /Kenneth

  • March 23, 2006 at 9:03 am

    #628380

    Something like this

    DECLARE @i INT

    SET @i = 1

    WHILE @i < 20

    BEGIN

     SELECT @i,

      CASE @i % 2

       WHEN 0 THEN 'Even'

       ELSE 'Odd'

      END AS OddOrEven

     SET @i = @i+1

    END

     

  • March 27, 2006 at 1:31 am

    #628825

    thanks guys - exactly what I need!

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply