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?

Expand your skills
Explore Training
Get new features first
Join Microsoft Insiders

Was this information helpful?

What affected your experience?

Thank you for your feedback!

×