﻿ Bitwise Functions
Nevron Vision for SharePoint Documentation
Pivot Engine / Functions / Bitwise Functions
In This Topic
Bitwise Functions
In This Topic
Syntax Description Example
BITAND(n1[, n2,... nN]) Returns a 32-bit binary number in which a bit is set to 1 if the corresponding bits in all numbers are 1. Otherwise, the bit is set to 0. BITAND(7,2)
Returns: 2
(7 = 0111, 2 = 0010)
BITNOT(nNumber) Returns a 32-bit binary number in which a bit is set to 1 if the corresponding bit in number is 0. Otherwise, the bit is set to 0. BITNOT(1)
Returns: 2 ^ 32 - 1
BITOR(n1[, n2,... nN]) Returns a 32-bit binary number in which a bit is set to 1 if the corresponding bits in at least one numbers is 1. Otherwise, the bit is set to 0. BITOR(5,3)
Returns: 7
(5 = 0101, 3 = 0011, 7 = 0111)
BITXOR(n1[, n2,... nN]) Returns a 32-bit binary number in which a bit is set to 1 if the corresponding bits in bn1 AND bn2 are different. Otherwise, the bit is set to 0. BITXOR(5,3)
Returns: 6
(5 = 0101, 3 = 0011, 6 = 0110)