Reverse - Returns the reverse of a character expression.
REVERSE( character_expression )
For Eg.
Select CompanyName,
Reverse(CompanyName) As ReverseName,
Reverse(Left(CompanyName,5)) As ReverseFirst5Char,
Reverse (Right (CompanyName,5)) As ReverseLast5Char
From Customers
Result