bitwise-and-equals-transact-sql.md

title	&= (Bitwise AND EQUALS) (Transact-SQL) | Microsoft Docs
ms.custom
ms.date	01/10/2017
ms.prod	sql-non-specified
ms.reviewer
ms.suite
ms.technology	database-engine
ms.tgt_pltfrm
ms.topic	language-reference
f1_keywords	&= &=_TSQL
dev_langs	TSQL
helpviewer_keywords	compound operators, &= &= (bitwise AND equals)
ms.assetid	f374c885-3fee-434a-93fb-dfe6e0bcd100
caps.latest.revision	15
author	BYHAM
ms.author	rickbyh
manager	jhubbard

&= (Bitwise AND EQUALS) (Transact-SQL)

[!INCLUDEtsql-appliesto-ss2008-all_md]

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

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 AND) (Transact-SQL).

See Also

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