Home Forums SQL Server 2008 T-SQL (SS2K8) Reverse Of Number without Using reverse() RE: Reverse Of Number without Using reverse()

  • August 4, 2012 at 3:11 am

    #1521691

    How about this Cadavre???.....

    Declare @num bigint

    Set @num = 12345678

    Select @num As Number, Stuff((select Left(Right(Cast(@num As Varchar(10)), n), 1) From Tally

    Where n <= Len(Cast(@num As Varchar(10))) For XML Path('')), 1, 1, Right(Cast(@num As Varchar(10)), 1)) As ReverseOfNumber

    😛

    Vinu Vijayan

    For better and faster solutions please check..."How to post data/code on a forum to get the best help" - Jeff Moden[/url] 😉