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 string value.

Topic link iconTransact-SQL Syntax Conventions


REVERSE (string_expression )

string_expression

string_expression is an expression of a string or binary data type. string_expression can be a constant, variable, or column of either character or binary data.

varchar or nvarchar

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

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

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

Here is the result set.

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

The following example reverses the characters in a variable.

DECLARE @myvar varchar(10)
SET @myvar = 'sdrawkcaB'
SELECT REVERSE(@myvar) AS Reversed ;
GO

The following example makes an implicit conversion from an int data type into varch data type and then reverses the result.

SELECT REVERSE(1234) AS Reversed ;
GO

Community Additions

ADD
Show:
© 2015 Microsoft