Edit

Share via

STRINGEQUALS (NoSQL query)

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

The STRINGEQUALS function returns a boolean indicating whether the first string expression matches the second.

An Azure Cosmos DB for NoSQL system function that returns a boolean indicating whether two strings are equivalent.

Syntax

STRINGEQUALS(<string_expr_1>, <string_expr_2> [, <boolean_expr>])

Arguments

Description
string_expr_1 The first string expression to compare.
string_expr_2 The second string expression to compare.
boolean_expr An optional boolean expression for ignoring case. When set to true, this function performs a case-insensitive search. If not specified, the default value is false.

Return types

Returns a boolean expression.

Examples

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

Compare string equality

In this example, the STRINGEQUALS function is used to check if two strings are equal, with and without case sensitivity.

SELECT VALUE {
  compareSameCase: STRINGEQUALS("AdventureWorks", "AdventureWorks"),
  compareDifferentCase: STRINGEQUALS("AdventureWorks", "adventureworks"),
  compareIgnoreCase: STRINGEQUALS("AdventureWorks", "adventureworks", true)
}

[
  {
    "compareSameCase": true,
    "compareDifferentCase": false,
    "compareIgnoreCase": true
  }
]

Remarks

  • This function performs an index seek.