| Subject | Re: [firebird-support] toggle betweenn 0 and 1 |
|---|---|
| Author | Josef Kokeš |
| Post date | 2014-04-03T05:06:43Z |
On 2.4.2014 9:26, Bogdan Mihalache wrote:
Doesn't need any functions, built-in or UDF.
Josef Kokes
>UPDATE table SET column=1-column WHERE id=:id
>
> Update table set *column = Mod(column+1,2)* where id = :id
Doesn't need any functions, built-in or UDF.
Josef Kokes