How to reverse a string(SQL SERVER 2005, SET BASED)
- by Newbie
E.g. 
Declare @str varchar2(20)
Set @str = 'A Student'
Select Reverse(@str)
Output:
tnedutS A
Expected being: 
Student A
The output(using Reverse) is as  expected. But my requirement is the one described.
Help needed with SET BASED.
I am using SQL SERVER 2005