How Can I determine is digit Even number?
t-sql
Solution
Use the modulus operator `n % 2`. It returns 0 if the number is even, and 1 if the number is odd.
Problem
Bit rusty on the old sql. Can you help? Given a number eg 1 or 2 or 4 I need to determine if it's even or odd number and do some calculation depending if even or odd . How do you detect that in sql (sql server 2000) thanks a lot