Export (0) Print
Expand All
Expand Minimize
0 out of 1 rated this helpful - Rate this topic

| (Bitwise OR) (SQL Server Compact)

Performs a bitwise logical OR operation between two given integer values as translated to binary expressions within SQL statements.


expression | expression
expression

Any valid expression in Microsoft SQL Server Compact of any of the data types of the integer data type category. The expression is an integer that is treated and transformed into a binary number for the bitwise operation..

Returns an int if the input values are int, a smallintif the input values are smallint, or a tinyint if the input values are tinyint.

The following example performs the bitwise OR operation between two integer columns.

CREATE TABLE bitwise (A int NOT NULL, B int NOT NULL)
INSERT bitwise VALUES (170, 75)
SELECT A | B FROM bitwise
--Returns 235

The binary representation of 170 (A) is 0000 0000 1010 1010. The binary representation of 75 (B) is 0000 0000 0100 1011. Performing the bitwise OR operation on these two values produces the binary result 0000 0000 1110 1011, which is decimal 235.

(A | B)
         0000 0000 1010 1010
         0000 0000 0100 1011
         -------------------
         0000 0000 1110 1011
Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback
Show:
© 2014 Microsoft. All rights reserved.