BIT_OR
BIT_OR (expression)
Description
Description
The bitwise OR of all non-null values. If no rows are selected, the result is NULL. Aggregates are only allowed in select statements.
A logical OR operation is performed on each pair of corresponding bits of two binary expressions of equal length.
In each pair, the result is 1 if the first bit is 1 OR the second bit is 1 OR both bits are 1, and otherwise the result is 0.
Updated about 5 years ago