Re: [firebird-support] toggle betweenn 0 and 1

[Josef Kokeš]

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