determine if number is odd even in tsql sql server
A user asked the best way to determine if the number is odd or even, there is no builtin SQL Server function in my knowledge which can simply return True False or tell if number is odd number or even number. There is another trick to check if number is odd or even.
Here is the T-SQL Script.
SELECT
Column_Name,
CASE WHEN cast(Column_Name as int) % 2 = 1
THEN 'Odd'
ELSE 'Even'
END
FROM Table_Name