reverse()

Switch services using the Version drop-down list. Learn more about navigation.
Applies to: ✅ Microsoft Fabric ✅ Azure Data Explorer ✅ Azure Monitor ✅ Microsoft Sentinel

Function reverses the order of the input string. If the input value isn't of type string, then the function forcibly casts the value to type string.

Syntax

reverse(value)

Learn more about syntax conventions.

Parameters

Name	Type	Required	Description
value	string	✔️	input value.

Returns

The reverse order of a string value.

Examples

Run the query

print str = "ABCDEFGHIJKLMNOPQRSTUVWXYZ"
| extend rstr = reverse(str)

Output

str	rstr
ABCDEFGHIJKLMNOPQRSTUVWXYZ	ZYXWVUTSRQPONMLKJIHGFEDCBA

Run the query

print ['int'] = 12345, ['double'] = 123.45, 
['datetime'] = datetime(2017-10-15 12:00), ['timespan'] = 3h
| project rint = reverse(['int']), rdouble = reverse(['double']), 
rdatetime = reverse(['datetime']), rtimespan = reverse(['timespan'])

Output

rint	rdouble	rdatetime	rtimespan
54321	54.321	Z0000000.00:00:21T51-01-7102	00:00:30