That's the most simple formula Josef but requires that COLUMN always be 1 or 0, never another number neither NULL.
Greetings. Walter. On Thu, Apr 3, 2014 at 1:06 AM, Josef Kokeš <[email protected]>wrote: > > > On 2.4.2014 9:26, Bogdan Mihalache wrote: > > > > > > Update table set *column = Mod(column+1,2)* where id = :id > > UPDATE table SET column=1-column WHERE id=:id > > Doesn't need any functions, built-in or UDF. > > Josef Kokes > >
