Re: SQL Syntax - like FIELD and BITPATTERN = BITPATTERN?

> I do not know how to really describe this...
>
> In pascal I would do
>
> If (AField and Flag3)=Flag3 then ...
>
> Checking to see if AField contains the BIT(s) FLAG3 is set to... is
> there a way to do this in a SELECT statement -- select * from ATable
> where AField and 0x0004=0x0004
>
> ?
>
> Thanks,
> O.
>
perhaps select * from ATable where AField::bit(16) & B'000000000100' = B'0000000000000100';

Allan

The material contained in this email may be confidential, privileged or copyrighted. If you are not the intended recipient, use, disclosure or copying of this information is prohibited. If you have received this document in error, please advise the sender and delete the document. Neither OneSteel nor the sender accept responsibility for any viruses contained in this email or any attachments.