Reverse the String in SQL Server.

Description:

In this example we explain that how to Reverse the string in SQL Server or how to fetch string in reverse  order from SQL Server.SQL Query to reverse the string or fetch the string in reverse order from SQL Server.

Here we use REVERSE() function of the SQL Server it was introduced in SQL Server 2008.REVERSE() function will returns the string in reverse order of inputted by user.if you pass the non alphabet character(Integer) value then it will first convert it into string and then it will return in reverse order.

Query:

SELECT REVERSE('Hello kirit') As string

SELECT REVERSE('12345') As Numeric