StrReverse Function

Applies To
Access for Microsoft 365 Access 2024 Access 2021 Access 2019 Access 2016

Returns a string in which the character order of a specified string is reversed.

Syntax

StrReverse⁠(⁠expression⁠)⁠

The required expression argument is the string whose characters are to be reversed. If expression is a zero-length string (""), a zero-length string is returned. If expression is Null, an error occurs.

Example

Expression Results
SELECT strReverse(ProductID) AS ReversedID FROM ProductSales; Returns the "ProductID" in reverse character order from the table "ProductSales" and displays the results in the column ReversedID.

String functions and how to use them