MS SQL Server
In Built Function in T-SQL - Reverse
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
Newer Post
Older Post
Home