Was this page helpful?
Your feedback about this content is important. Let us know what you think.
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All
Expand Minimize

REVERSE (Transact-SQL)

Returns the reverse of a character expression.

Topic link icon Transact-SQL Syntax Conventions

REVERSE ( character_expression )


Is an expression of character data. character_expression can be a constant, variable, or column of either character or binary data.

varchar or nvarchar

character_expression must be of a data type that is implicitly convertible to varchar. Otherwise, use CAST to explicitly convert character_expression.

The following example returns all contact first names with the characters reversed.

USE AdventureWorks;
SELECT FirstName, REVERSE(FirstName) AS Reverse
FROM Person.Contact
WHERE ContactID < 5
ORDER BY FirstName;

Here is the result set.

FirstName      Reverse
-------------- --------------
Catherine      enirehtaC
Gustavo        ovatsuG
Humberto       otrebmuH
Kim            miK
(4 row(s) affected)

Community Additions

© 2015 Microsoft