NexusDB

DROP FUNCTION IF EXISTS "BITAND";
CREATE FUNCTION BITAND (N1 INTEGER, N2 INTEGER)
RETURNS INTEGER
BEGIN
  DECLARE nReturnValue,nS Integer DEFAULT 0;
  WHILE N1 > 0 AND N2 > 0 AND nS < 32 DO
    SET nReturnValue = nReturnValue + MOD(N1,2) * MOD(N2,2)* POWER(2,nS);
    SET N1 = N1 / 2;
    SET N2 = N2 / 2;
    SET nS = nS + 1;
  END WHILE;
  RETURN nReturnValue;
END