How to reverse a string in MS-Sql Server without using REVERSE() function

How to reverse a string in MS-Sql Server without using REVERSE( ) function

    Its simple ,Try following query  

its one of the interview question in these days

DECLARE @Str VARCHAR (50)='MS SQL'
DECLARE @Result VARCHAR (50)=''
DECLARE @Len INT

SET @Len=LEN (@Str)

               

           WHILE (0<@Len)

           BEGIN

                 SET @Result=@Result+SUBSTRING (@Str,@Len,1)

                 SET @Len=@Len-1

          END

PRINT @Result

OUT PUT :