Subject | Re: [firebird-support] NOT in Firebird |
---|---|
Author | Mark Rotteveel |
Post date | 2013-07-04T09:16:59Z |
On Thu, 4 Jul 2013 10:34:21 +0200, "Olaf Kluge" <olaf.kluge@...>
wrote:
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
wrote:
> for example there are two variables.Var2
>
> Var1 = 0
>
> Now I would like to negate the Var1 to Var2. If var1 = 0, then should
> =Is this just about 0 and 1 or other values as well, if so what is the
> 1 and in the other direction.
>
> Ist it possible Var2 = invert(var1)??
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