Tuesday, June 21, 2022

StrReverse Function [MS]

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

No comments:

Post a Comment

Search This Blog

Use a keyboard to customize the Quick Access Toolbar [MS]

Use a keyboard to customize the Quick Access Toolbar Office 2021 Office...