Something like this might work (?) update table set value = abs(value-1) ? 0 - 1 = -1 -> abs(-1) = 1 1 - 1 = 0 -> abs(0) = 0 -- edmz | http://www.edmz.org