AppDividend
Latest Code Tutorials

SQL REVERSE Function Example | SQL Server REVERSE()

0

SQL REVERSE() function is used for reversing the string. It accepts a string of characters as an argument and returns the reverse order of the string. The REVERSE is one of the SQL String Functions, which is used to reverse the specified expression. The REVERSE() function reverses a string and returns the result.

SQL REVERSE Function

The REVERSE function is used to reverse the given string.

See the following syntax of the REVERSE function.

Syntax

SELECT REVERSE(string)

Parameters

String: It is the source string of which characters have to be reversed.

Note

The string expression must be of a data type that can be implicitly converted to VARCHAR. Otherwise, CAST has to be used explicitly for converting to VARCHAR.

Example

See the following query.

SELECT REVERSE ('AppDividend.com');

Output

moc.dendiviDppA

Query 2

SELECT REVERSE ('edcba');

Output

abcde

Query 3

SELECT REVERSE (' SQL');

Output

LQS

Query 4

SELECT REVERSE ('123');

Output

321

Above were the common examples to make clear how this function work. Let’s apply this function to a TABLE.

Table: Employee

Emp_idFirst_nameCityStatePhone
101RohitPatnaBihar8585145852
201ShivamJalandharPunjab8958458785
301KaranAllahabadUttar Pradesh9987845784
401SurajKolkataWest Bengal88789898980
501AkashVizagAndhra Pradesh98985475001

 

Suppose we want to reverse the first_name of the employee, then the following query has to be considered.

Query

Select First_name, REVERSE (First_name) 
AS Reversed_Name 
from Employee;

Output

First_nameReversed_Name
RohittihoR
ShivammavihS
KarannaraK
SurajjaruS
AkashhsakA

 

Here, you can see that the First_name of the employee has been reversed.

SQL SERVER Reverse Function

Let’s use SQL SERVER REVERSE function to check whether a string is a palindrome or not.

A palindrome string is a string whose original and reversed strings are equal.

EX: MaM, DaD

Query

DECLARE 
@input VARCHAR (100) = 'MadaM';
SELECT 
CASE
WHEN @input = REVERSE(@input)
THEN 'Palindrome'
ELSE 'Not Palindrome'
END result;

Output

Palindrome

Explanation

Here, above string MadaM, which was given as input, was a palindrome.

MySQL REVERSE() Function

MySQL REVERSE() function reverses a string and returns the result.

It works from MySQL 4.0.

Finally, SQL REVERSE Function Example Tutorial is over.

Recommended Posts

SQL TRANSLATE Function

SQL Replicate Function

SQL LTRIM Function

SQL UPPER Function

SQL UNICODE Function

Leave A Reply

Your email address will not be published.

This site uses Akismet to reduce spam. Learn how your comment data is processed.