SQL server (not equal to equal to) conditional operator

equal to condition 

SELECT * 

FROM table_name  

WHERE mod(column_name,2) = 0;

------------------------------

Not equal to condition 

SELECT * 

FROM table_name  

WHERE mod(column_name,2) <> 0;