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. |