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;