--


DECLARE @StringToReverse VARCHAR(55) = ''
SET @StringToReverse = 'Reverse a string with out using REVERSE() function'
DECLARE @Output AS VARCHAR(100) = ''

IF OBJECT_ID('tempdb..#x') IS NOT NULL
    DROP TABLE #x

SELECT NUMBER, SUBSTRING(@StringToReverse,Number,1) Chr, ROW_NUMBER() OVER (ORDER BY Number DESC) r INTO #x FROM 
( 

	SELECT 
		  DISTINCT NUMBER 
	FROM 
		  MASTER..SPT_VALUES
	WHERE
		  NUMBER > 0 AND NUMBER <= DATALENGTH(@StringToReverse) 

)h
ORDER BY NUMBER DESC

SELECT @Output=@Output+Chr FROM #x

SELECT @StringToReverse InputStr , @Output OutputStr

IF OBJECT_ID('tempdb..#x') IS NOT NULL
    DROP TABLE #x


--