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

The REVERSE function returns the reverse order of a string value.

An Azure Cosmos DB system function that returns a reversed string.

Syntax

REVERSE(<string_expr>)

Arguments

Return types

Returns a string expression.

Examples

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

Reverse string value

In this example, the function reverses multiple strings.

SELECT VALUE {
  reverseAdventureWorks: REVERSE("AdventureWorks"),
  reverseAdventureWorksBack: REVERSE("skroWerutnevdA"),
  doubleReverseAdventureWorks: REVERSE(REVERSE("AdventureWorks"))
}

[
  {
    "reverseAdventureWorks": "skroWerutnevdA",
    "reverseAdventureWorksBack": "AdventureWorks",
    "doubleReverseAdventureWorks": "AdventureWorks"
  }
]

Remarks

• This function doesn't utilize the index.