Modulo Question for SQL Server

[KIDDIE]

SELECT
ACCOUNT_NUMBER,
EM_NO + IN_BANK + NT_BANK AS SPA,
CURRENT_BALANCE,
CYCLE_CODE_99

FROM
dbo.MASTER_CUR
WHERE
((EM_NO + IN_BANK + NT_BANK) IN
('502650000000', '851190000000')) AND
(CURRENT_BALANCE between 1600 AND 5000)and
CYCLE_CODE_99 in(2,4,6,8,12,14,16,18,20)


All I need is the the Even numbered cycle codes?
How can write this query without hard coding Cycle code? Thank you

 

[Tim1]

Hiya,

You could try

SELECT
ACCOUNT_NUMBER,
EM_NO + IN_BANK + NT_BANK AS SPA,
CURRENT_BALANCE,
CYCLE_CODE_99

FROM
dbo.MASTER_CUR
WHERE
((EM_NO + IN_BANK + NT_BANK) IN
('502650000000', '851190000000')) AND
(CURRENT_BALANCE between 1600 AND 5000)and
CYCLE_CODE_99 % 2 = 0

The %2 = 0 will basicaly perform a divide by 2 and then check to see if the number is an integer. If so, it will be true, if not, it will be false.

HTH

Tim