In this step by step SQL Tutorial I will show you how to use REVERSE() function. For the purpose of this tutorial I will use SQL Server 2012.
Other Versions of SQL Server:
- SQL Server 2012
- This blog post has been written using SQL Server 2012
- SQL Server 2008 / R2
- The examples we used should work in SQL Server 2008 and R2
- SQL Server 2005
- We suspect that this will work in SQL Server 2005 as well
Returns the reverse order of a string value. For instance word 'cat' reversed becomes 'tac'.
REVERSE Function - Is used to return the reverse order of a string value.
REVERSE (<<Input Value>>)
<<Input Value>> - Provide string value (field name or expression) that will be used as your input.
In this example I use REVERSE() function to reverse FirstName field.
I hope that will help you