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

RIGHT (Transact-SQL)

Returns the right part of a character string with the specified number of characters.

Topic link icon Transact-SQL Syntax Conventions


RIGHT ( character_expression , integer_expression )

character_expression

Is an expression of character or binary data. character_expression can be a constant, variable, or column. character_expression can be of any data type, except text or ntext, that can be implicitly converted to varchar or nvarchar. Otherwise, use the CAST function to explicitly convert character_expression.

integer_expression

Is a positive integer that specifies how many characters of the character_expression will be returned. If integer_expression is negative, an error is returned. integer_expression can be of type bigint.

varchar or nvarchar

Compatibility levels can affect return values. For more information, see sp_dbcmptlevel (Transact-SQL).

The following example returns the five rightmost characters of the first name for each contact.

USE AdventureWorks;
GO
SELECT RIGHT(FirstName, 5) AS 'First Name'
FROM Person.Contact
WHERE ContactID < 5
ORDER BY FirstName;
GO

Here is the result set.

First Name
----------
erine
stavo
berto
Kim

(4 row(s) affected)

Community Additions

ADD
Show:
© 2015 Microsoft