title: facing issues with bitwise AND operation
body: <p>I am using SQl database</p>
  
  <p>I have one table having column datatype Blob.</p>
  
  <pre><code>for e.g:
  create table Alarm(
  id int,
  xyz blob
  );
  </code></pre>
  
  <p>this is my insert statements:</p>
  
  <p>INSERT INTO Alarm values(2, '1000001'); </p>
  
  <p>INSERT INTO Alarm values(5, '0001000');</p>
  
  <p>INSERT INTO Alarm values(7, '0110110');</p>
  
  <p>this is my SELECT statement</p>
  
  <p>SELECT * from Alarm where xyz &amp; cast('1001001' as blob); </p>
  
  <p>When I am using <strong>Bitwise AND</strong> operation it returns all records from table.
  But in this scenario records 1 &amp; 2 should be selected.</p>
  
  <p>the <strong>select</strong> statement returns all records which is wrong.</p>
  
  <p>please help me out.</p>