# ^ (Bitwise Exclusive OR) (SSIS Expression)

### In this article

**APPLIES TO:** SQL Server, including on Linux Azure SQL Database Azure SQL Data Warehouse Parallel Data Warehouse

Performs a bitwise exclusive OR operation of two integer values. It compares each bit of its first operand to the corresponding bit of its second operand. If one bit is 0 and the other bit is 1, the corresponding result bit is set to 1. If both bits are 0 or both bits are 1, the corresponding result bit is set to 0.

Both conditions must be a signed integer data type or both conditions must be an unsigned integer data type.

## Syntax

```
integer_expression1 ^ integer_expression2
```

## Arguments

*integer_expression1, integer_expression2*

Is any valid expression of a signed or unsigned integer data type. For more information, see Integration Services Data Types.

## Result Types

Determined by data types of the two arguments. For more information, see Integration Services Data Types in Expressions.

## Remarks

If either condition is null, the expression result is null.

## Expression Examples

This example performs a bitwise exclusive OR operation between variables **NumberA** and **NumberB**. **NumberA** contains 3 (00000011) and **NumberB** contains 7 (00000111).

```
@NumberA ^ @NumberB
```

The expression evaluates to 4 (00000100).

00000011

00000111

-----------

00000100

This example performs a bitwise exclusive OR operation between the **ReorderPoint** and **SafetyStockLevel** columns.

```
ReorderPoint ^ SafetyStockLevel
```

If **ReorderPoint** is 10 and **SafetyStockLevel** is 8, the expression evaluates to 2 (00000010).

00001010

00001000

-----------

00000010

This example performs a bitwise exclusive OR operation between two integers.

```
3 ^ 5
```

The expression evaluates to 6 (00000110).

00000011

00000101

-----------

00000110

## See Also

|| (Logical OR) (SSIS Expression)

| (Bitwise Inclusive OR) (SSIS Expression)

Operator Precedence and Associativity

Operators (SSIS Expression)