-- Setup a table with some integers
CREATE TABLE ints(INT INTEGER);
INSERT INTO ints VALUES (-1);
INSERT INTO ints VALUES (0);
INSERT INTO ints VALUES (1);
INSERT INTO ints VALUES (2);

-- Are they even or odd?
SELECT
  INT,
  CASE MOD(INT, 2) WHEN 0 THEN 'Even' ELSE 'Odd' END
FROM
  ints;