The SQL REVERSE is one of the SQL String Function, which is used to reverse the specified expression. In this article we will show you, How to write REVERSE Function in SQL Server 2014 with example.
Syntax of a REVERSE in SQL
The basic syntax of the REVERSE Function In SQL Server is as shown below:
|
1 2 |
SELECT REVERSE (String_Expression) FROM [Source] |
We are going to use the below shown data to explain the REVERSE Function in SQL Server 2014
SQL REVERSE Function Example 1
The REVERSE Function is used to reverse the given string. The following query will show multiple ways to use REVERSE Function in SQL Server.
T-SQL CODE
|
1 2 3 4 5 6 7 |
DECLARE @String_Expression varchar(50) SET @String_Expression = 'SQL Server' SELECT REVERSE (@String_Expression) AS 'SQLReverse' --String Reverse directly SELECT REVERSE ('SQL Server 2014') AS 'SQL Reverse' |
OUTPUT
ANALYSIS
Below lines of code is used to declare string variable and assigning the string data.
|
1 2 |
DECLARE @String_Expression varchar(50) SET @String_Expression = 'SQL Server' |
In the below statement, We used REVERSE function to reverse the string variable @String_Expression. We also assigned new name to that result using ALIAS Column.
|
1 |
SELECT REVERSE (@String_Expression) AS 'SQL Reverse' |
In the next line, We used the REVERSE Function directly on the string.
|
1 2 |
--String Reverse directly SELECT REVERSE ('SQL Server 2014') AS 'SQL Reverse' |
SQL REVERSE Function Example 2
The REVERSE function also allows you to reverse the expressions inside the columns. In this example, We are going to reverse all the records present in [Department Name].
T-SQL CODE
|
1 2 3 4 5 |
SELECT [FirstName] ,[LastName] ,[DepartmentName] ,REVERSE ([DepartmentName]) AS [SQL Reverse] FROM [Employe] |
OUTPUT
Thank You for Visiting Our Blog
Leave a Reply