Embarrassingly Simple SQL Server query: List Even numbers in....

[WWGD]

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.

 

[jedishrfu]

Mysql has the mod(number,base) alternative to try instead of the % operator

https://dev.mysql.com/doc/refman/5.7/en/mathematical-functions.html#function_mod

In your example, one thing you might try is to place parens around the mod operation in case its a precedence issue.

http://www.plus2net.com/sql_tutorial/sql-mod.php

 

[jedishrfu]

One other thought is the % character is used to identify script parameters on windows (%1, %2, %3 ...) so if your sql is in such a script then that could be why its not working and why the mod() function would be a better choice.

Here's some writeup for Windows-XP which is probably still somewhat valid today:

https://www.microsoft.com/resources...docs/en-us/ntcmds_shelloverview.mspx?mfr=true

 

[WWGD]

Thanks, Jedi, the strange thing is that the query actually runs , but returns incorrect results.

 

[jedishrfu]

Could it be evaluating the query as?

SELECT [FieldName] FROM Table WHERE [FieldName]  =0 ;

where the %2 has been removed.

 

[WWGD]

Could it be evaluating the query as?

SELECT [FieldName] FROM Table WHERE [FieldName]  =0 ;

where the %2 has been removed.

I don't think so, since [FieldName] is the primary key. There may be a bug in the server or the (client) computer.

 

[WWGD]

I don't think so, since [FieldName] is the primary key. There may be a bug in the server or the (client) computer.

Thanks for the effort, though, a tough one.

 

[jedishrfu]

Try typing in the query without the %2 and see if you get the same result set.