The REVERSE() function in SQL Server is a simple and powerful tool designed to reverse the order of characters in a string. By taking a string input, it returns a new string with its characters arranged in the opposite sequence.

In this article, We will learn to REVERSE() Functions in SQL Server by understanding various examples in detail.

SQL Server REVERSE() Function

• The REVERSE() function in SQL Server is used to reverse the characters in a string.
• This function takes a string as input and returns a new string where the characters are arranged in reverse order.

Features of REVERSE() Function in SQL Server

• This function is used to reverse the order of characters in the specified string.
• This function accepts strings as parameters.
• This function always returns a string.
  
• This function can also reverse a string representation of integers.
• This function can even reverse float values.

Syntax:

REVERSE(string)

Parameter : This method accepts only one parameter as given below :

• string : Specified string to be reversed.

Returns:

It returns the stated string in the reversed form.

Example 1: Reversing a String

Reverse the characters of the string ‘gfG‘.

SELECT REVERSE('gfG');

Output:

Gfg

Explanation: The REVERSE() function converts ‘gfG’ to ‘Gfg’, reversing the order of characters.

Example 2: Reversing a String from a Variable

Reverse the characters of a string stored in a variable.

DECLARE @string VARCHAR(15);  
SET @string = 'geeksforGeeks';  
SELECT REVERSE(@string);

Output:

skeeGrofskeeg

Explanation: The function reverses the string ‘geeksforGeeks‘, resulting in ‘skeeGrofskeeg‘.

Example 3: Reversing a Set of Integers

Reverse the digits of the integer 123.

SELECT REVERSE(123);

Output:

321

Explanation: The function treats the integer 123 as a string and reverses it to produce ‘321’.

Example 4: Reversing a Float Value

Reverse the characters of the float value 1.56.

SELECT REVERSE(1.56);

Output:

65.1

Explanation: The function converts the float 1.56 to the string ‘1.56’ and then reverses it to ‘65.1’.

Conclusion

The REVERSE() function in SQL Server is a versatile tool for string manipulation. It can handle not only text strings but also numeric values, converting them into strings and reversing their order. This function is particularly useful in scenarios requiring string reformatting or data processing.

nidhi1352singh

Follow

Improve

Article Tags :

• Databases
• SQL
• DBMS-SQL
• SQL-Server