bitwise-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 OR)	SQL Server (Transact-SQL)	|= (Bitwise OR Assignment) (Transact-SQL)	rwestMSFT	randolphwest	01/10/2017	sql	t-sql	reference	ignite-2024	|= |=_TSQL	compound operators, |= assignment operators, |= augmented operators, |= |= (bitwise OR equals)	TSQL	>=aps-pdw-2016 || =azuresqldb-current || =azure-sqldw-latest || >=sql-server-2016 || >=sql-server-linux-2017 || =azuresqldb-mi-current || =fabric

|= (Bitwise OR Assignment) (Transact-SQL)

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

Performs a bitwise logical OR operation between two specified integer values as translated to binary expressions within [!INCLUDEtsql] statements, 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 OR) (Transact-SQL).

See Also

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