Here's another method:

-- Parameters

DECLARE @String VARCHAR(8000)

SET @String = 'Reverse'

-- Local Variables

DECLARE @OutputString VARCHAR(8000); SET @OutputString = '';

DECLARE @StrLen INT; SET @StrLen = DATALENGTH(@String);

DECLARE @MappingTable TABLE (n INT PRIMARY KEY CLUSTERED);

INSERT INTO @MappingTable (n)

SELECT TOP(@StrLen) n = ROW_NUMBER() OVER (ORDER BY (SELECT NULL)) FROM syscolumns a, syscolumns b;

UPDATE @MappingTable SET @OutputString = @OutputString + SUBSTRING(@String,(@StrLen+1)-n,1);

SELECT FormattedAmount = @OutputString;