Subject AW: [firebird-support] NOT in Firebird
Author Olaf Kluge
Hello Mark,



great, exactly what I was looking for. Only 1 and 0 is possible.



Thank you.



Olaf

On Thu, 4 Jul 2013 10:34:21 +0200, "Olaf Kluge" < <mailto:olaf.kluge%40satron.de> 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





[Non-text portions of this message have been removed]