Subject Re: [firebird-support] NOT in Firebird
Author Mark Rotteveel
On Thu, 4 Jul 2013 10:34:21 +0200, "Olaf Kluge" <olaf.kluge@...>
wrote:
> for example there are two variables.
>
> Var1 = 0
>
> Now I would like to negate the Var1 to Var2. If var1 = 0, then should
Var2
> =
> 1 and in the other direction.
>
> Ist it possible Var2 = invert(var1)??

Is this just about 0 and 1 or other values as well, if so what is the
exact transformation you need?

In this specific case, assuming var1 is always 1 or 0 you can use
BIN_XOR(var1, 1) to achieve the desired effect.

Mark