By: Daniel Calbimonte
The REVERSE function is used to provide the string characters in the reverse order.
Syntax
REVERSE(expression)
Parameters
- expression - this is a string, number, binary data or expression to be reversed.
Simple REVERSE Example
Below is a simple example of using REVERSE function to reverse the word ROME.
SELECT REVERSE('ROME') as msg
REVERSE Example Using a Table
The following example will reverse the FirstName from the Person table.
SELECT FirstName, REVERSE(FirstName) as reversename FROM [Person].[Person]
REVERSE Example with Numbers
The following example will reverse the numbers.
SELECT REVERSE(12345) as msg
REVERSE with NULL values
If the parameter is NULL the value returned by the function will be null as well.
SELECT REVERSE(null) as msg
RVEVERSE Function with RIGHT and CHARINDEX
In this example, we want to get the text after the colon. We will get the position of the colon counting from the right using the reverse function and then we will use the RIGHT function to get the text to the right of the colon.
DECLARE @string nvarchar(20) = 'Example:New'
DECLARE @position int = CHARINDEX(':',REVERSE(@string))-1
SELECT RIGHT(@string, @position) output
