reverse

Returns the specified string with characters listed in reverse order.

Syntax

reverse(expression | uchar_expr)

Parameters

expression – is a character or binary-type column name, variable, or constant expression of char, varchar, nchar, nvarchar, binary, or varbinary type.
uchar_expr – is a character or binary-type column name, variable, or constant expression of unichar or univarchar type.

Examples

Example 1 – Returns "abcd" in reverse:
```
select reverse("abcd")
```
```
---- 
dcba
```
Example 2 – Returns the reverse of 0x12345000:
```
select reverse(0x12345000)
```
```
----------
0x00503412
```

Usage

reverse, a string function, returns the reverse of expression.
If expression is NULL, reverse returns NULL.
Surrogate pairs are treated as indivisible and are not reversed.

See also Transact-SQL Users Guide.

Standards

ANSI SQL – Compliance level: Transact-SQL extension.

Permissions

Any user can execute reverse.

Parent topic: Transact-SQL Functions

Related reference

Created May 28, 2014. Send feedback on this help topic to Technical Publications: pubs@sap.com