You are not using Oracle, so you should be using the modulus operator:
SELECT * FROM Orders where OrderID % 2 = 0;
The MOD() function exists in Oracle, which is the source of your confusion.
Have a look at this SO question which discusses your problem.