I'm passing a straightforward query that looks for particular rows where OrderID is an even number.
SELECT *
FROM Orders
WHERE mod(OrderID,2) = 0;
Error :
Syntax error (missing operator) in query expression 'mod(OrderID,2) = 0'.
Can someone please help me solve this?