RE: binary expression in SQL

Informix uses bit values in the sysmaster database. Search for bitval in $INFORMIXDIR/etc/sysmaster.sql for their stored procedure and examples of its use. -----Original Message----- From: root To: informix-list@iiug.org Sent: 1/28/01 5:10 AM Subject: binary expression in SQL Hi all, I do have the following problem. I am using an integer within a table to store bitcoded status information. This is a very efficient way (I think). But SQL only supports bool operators and mathematical functions to retrieve and search for matching columns. Is there any known way to search an entry that matches a binary mask? Currently I am retrieving all columns with a scroll cursor and doing the binary or-check within my C-code. It would be much nicier if there was a way to only get rows where the search key matches the binary searchword. Any help is higly appreciated