Subject Re: [firebird-support] toggle betweenn 0 and 1
Author W O
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Ň° <j.kokes@...> 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