Not (@myBit) is not working

31 Aug 2006 11:14 AM

Andreas Klemt

Hello,

I have this

DECLAR @myBit bit
SELECT @myBit = 1 --This means true

Now I want to do the negative out of it like

SELECT NOT (@myBit)

but this does not working. How can I do this?

Thanks for any help in advance!

Regards
Andreas klemt

31 Aug 2006 11:31 AM

Harsh Athalye

DECLARe @myBit bit
SELECT @myBit = 1
select ~@myBit

--
Regards,
Harsh Athalye
"Nothing is impossible"

Show quote

"Andreas Klemt" wrote:

> Hello,
>
> I have this
>
> DECLAR @myBit bit
> SELECT @myBit = 1 --This means true
>
> Now I want to do the negative out of it like
>
> SELECT NOT (@myBit)
>
> but this does not working. How can I do this?
>
> Thanks for any help in advance!
>
> Regards
> Andreas klemt
>
>
>

31 Aug 2006 11:46 AM

Andreas Klemt

Hello Harsh,

thank you very much!

Kind Regards
Andreas Klemt

Show quote

"Harsh Athalye" <HarshAtha***@discussions.microsoft.com> schrieb im
Newsbeitrag news:694E2F7D-AEDA-418D-90DB-5AE36F3C65F2@microsoft.com...
> DECLARe @myBit bit
> SELECT @myBit = 1
> select ~@myBit
> --
> Regards,
> Harsh Athalye
> "Nothing is impossible"
>
>
> "Andreas Klemt" wrote:
>
>> Hello,
>>
>> I have this
>>
>> DECLAR @myBit bit
>> SELECT @myBit = 1 --This means true
>>
>> Now I want to do the negative out of it like
>>
>> SELECT NOT (@myBit)
>>
>> but this does not working. How can I do this?
>>
>> Thanks for any help in advance!
>>
>> Regards
>> Andreas klemt
>>
>>
>>