Share via

INTBITXOR - Query language in Cosmos DB (in Azure and Fabric)

  • Applies to: ✅ Azure Cosmos DB for NoSQL, ✅ Cosmos DB in Microsoft Fabric

The INTBITXOR function returns the result of a bitwise exclusive OR operation on two integer values.

Syntax

INTBITXOR(<numeric_expr_1>, <numeric_expr_2>)

Arguments

Description
numeric_expr_1 The first numeric expression.
numeric_expr_2 The second numeric expression.

Return types

Returns a numeric expression.

Examples

This section contains examples of how to use this query language construct.

Bitwise exclusive OR

In this example, the INTBITXOR function is used to perform a bitwise exclusive OR operation.

SELECT VALUE {
  exclusiveOr: INTBITXOR(56, 100),
  exclusiveOrSame: INTBITXOR(56, 56),
  exclusiveOrZero: INTBITXOR(56, 0),
  exclusiveOrDecimal: INTBITXOR(56, 0.1)
}

[
  {
    "exclusiveOr": 92,
    "exclusiveOrSame": 0,
    "exclusiveOrZero": 56
  }
]
  • Last updated on