ok i'm getting close;

if i switch your values to BigEndian instead of Little, i'm getting your string, but backwards; i cannot seem to get it converted back to the last reverse that is needed.

/*

NormalConvertBigEndian

$1 egaP thgilF rof eeF noitcasnarT

*1 egaP thgilF rof eeF noitcasnarT noddA

*/

DECLARE @MyTable TABLE(id int identity(1,1) NOT NULL PRIMARY KEY,val varbinary(max))

INSERT INTO @MyTable(val)

SELECT 0x24005472616E73616374696F6E2046656520666F7220466C6967687420506167652020202031 UNION ALL

SELECT 0x2A004164646F6E205472616E73616374696F6E2046656520666F7220466C6967687420506167652020202031

SELECT CONVERT(VARCHAR(max),val) As NormalConvert,

CONVERT(VARCHAR(max),cast(reverse(val) as varbinary(max))) AS BigEndian

FROM @MyTable