Mod negative numbers in SQL just like excel
sql, t-sql
Solution
This will give a result between 0 and n - 1 for both positive and negative values of x:
((x % n) + n) % n
Problem
I'm having trouble replicating the mod function in SQL sever. In excel, mod (-3, 7) = 4. But in SQL, -3 % 7 = -3 Am I using % wrong, or does SQL do mod differently?