Subject | AW: [firebird-support] NOT in Firebird |
---|---|
Author | Olaf Kluge |
Post date | 2013-07-04T10:23:46Z |
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:
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]
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.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
[Non-text portions of this message have been removed]