BITOR

Description

Performs a bitwise OR operation on two integers.

Supported integer types: TINYINT, SMALLINT, INT, BIGINT, LARGEINT

Syntax

BITOR(<lhs>, <rhs>)

Parameters

• <lhs>: The first integer for the operation.
• <rhs>: The second integer for the operation.

Return Value

Returns the result of the bitwise OR operation between the two integers.

Examples

1. Example 1
   select BITOR(3,5), BITOR(4,7);

   +------------+------------+
   | BITOR(3,5) | BITOR(4,7) |
   +------------+------------+
   |          7 |          7 |
   +------------+------------+

2. NULL argument
   select BITOR(3, NULL), BITOR(NULL, 5), BITOR(NULL, NULL);

   +----------------+----------------+-------------------+
   | BITOR(3, NULL) | BITOR(NULL, 5) | BITOR(NULL, NULL) |
   +----------------+----------------+-------------------+
   |           NULL |           NULL |              NULL |
   +----------------+----------------+-------------------+