filtering recordset in ASP

[trumpet]

Hi guys,

Trying to filter a recordset to display records with even ID numbers: am trying to filter where

ID/2= (integer)

Anyone know the ASP command for that integer? Have tried cINT and int() but neither play - suspect my dodgy syntax. cheers!

[WebJoe]

Try

ID Mod 2 = 0