Bitwise operators on Informix DB

Posted in 1998

Lucabond — Thu, 17 Dec 1998 15:18:16 +0100 — source: Informix-list mailing list archive (1991-1998)

I have to perform a bitwise comparison (and) between two integer numbers inside a SQL query on a Informix DB (ver. 5.01 and 7.1), SO HP-UX 9.04. I would appreciate help, because the system doesn't accept these kinds of statement: select count(*) from table where (field1 and integer) <> 0<syntax error> select count(*) from table where (field1 & integer) <> 0 <illegalcharacter> Regards Lucabond