bitwise-exclusive-or-equals-transact-sql.md

title	titleSuffix	description	author	ms.author	ms.date	ms.service	ms.subservice	ms.topic	ms.custom	f1_keywords	helpviewer_keywords	dev_langs	monikerRange
^= Bitwise Exclusive OR Assignment	SQL Server (Transact-SQL)	Bitwise exclusive OR operation between two integer values, and sets a value to the result of the operation.	rwestMSFT	randolphwest	01/10/2017	sql	t-sql	reference	ignite-2024	^= ^=_TSQL	^= (bitwise exclusive OR equals) compound operators, ^= assignment operators, ^= augmented operators, ^=	TSQL	>=aps-pdw-2016 || =azuresqldb-current || =azure-sqldw-latest || >=sql-server-2016 || >=sql-server-linux-2017 || =azuresqldb-mi-current || =fabric

^= (Bitwise Exclusive OR Assignment) (Transact-SQL)

[!INCLUDE sql-asdb-asdbmi-asa-pdw-fabricse-fabricdw-fabricsqldb]

Performs a bitwise exclusive OR operation between two integer values, and sets a value to the result of the operation.

:::image type="icon" source="../../includes/media/topic-link-icon.svg" border="false"::: Transact-SQL syntax conventions

Syntax

expression ^= expression  

Arguments

expression
Is any valid expression of any one of the data types in the numeric category except the bit data type.

Result Types

Returns the data type of the argument with the higher precedence. For more information, see Data Type Precedence (Transact-SQL).

Remarks

For more information, see ^ (Bitwise Exclusive OR) (Transact-SQL).

See Also

Compound Operators (Transact-SQL)
Expressions (Transact-SQL)
Operators (Transact-SQL)
Bitwise Operators (Transact-SQL)