Reverse String In SQL Server Without REVERSE Function

Govinda Rajulu Yemineni

11y20kCode

In this code snippet I will show you how to Reverse String In SQL Server Without REVERSE Function.

CREATE function StringReverse(@inputstring varchar(max))
returns varchar(max)
AS
BEGIN
  DECLARE @i int,
          @Result varchar(max)
  SET @Result=''
  SET @i = 1
  WHILE @i <= LEN(@inputstring)
  BEGIN
    SET @Result = SUBSTRING(@inputstring,@i,1) + @Result
    SET @i=@i + 1
  END
  RETURN @Result
END

Execution of Function:

select dbo.StringReverse('xyz123abc')

Result:

cba321zyx