Applies ToAccess 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

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.