Hi, I am trying to find all the even numbers in [FieldName] in SQL Server. My query is : SELECT [FieldName] FROM Table WHERE [FieldName] % 2 =0 ; I only get an error message . ( I am using SQL Zoo, since I don't have SQL server available at the moment. Only message I get is that the query is incorrect. I am trying to avoid using T-Sql, variables, etc.