Right im quite new to this ASP thing, i need to select Odd and Even Numbers in a record set using dreamweaver.

I have a Table with a cakeID that generates an autonumber. I would like my recordset to look at this and only select either odd or even numbers....

Im completely stuck and its probably really simple, but please help me..

Thanks for any help in advance!!!! you can email me with the answer if you like

what database are you using. SQL has the modulo (remainder) operator

Was using Access, Managed to figure it out in the end...