BITAND()

Purpose

Function to perform bitwise AND operation

Syntax

BITAND(<expN1>,<expN2>[,…<expN26>])

See Also

BITCLEAR(), BITLSHIFT(), BITNOT(), BITOR(), BITRSHIFT(), BITSET(), BITTEST(), BITXOR()

Description

The BITAND() function performs a bitwise AND operation on the specified numeric parameters. Up to 26 parameters can be specified. These parameters, if not integers, will be converted to integer values before the operation takes place.

BITAND() compares each bit in turn of <expN1> and <expN2>. If both bits are 1, the corresponding bit in the result is set to 1, otherwise the result bit is 0. If <expN3> is specified, the initial result is compared bit by bit with <expN3> and a new result evaluated. This new result is then compared with <expN4>, if specified, and so on.

<expN1> bit	<expN2> bit	Result bit
0	0	0
0	1	0
1	1	1
1	0	0

Example

x = 3   && 0011
y = 6   && 0110
z = 7	&& 0111
? bitand(x,y)
         2     && 0010
? bitand(x,y,z)
         2     && 0010

Products

Recital Server, Recital