MOD operator in where clause

Question

I am getting an invalid number exception. How do you use MOD in WHERE clause? I am wanting to update even or odd rows based on ID.

update employee  set respstr1 = 'EP' where mid = 7246 and (mod(id/2) = 1)

Answer 1

Correct syntax for mod is

mod(id,2)