right

Returns the part of the character or binary expression starting at the specified number of characters from the right. Return value has the same datatype as the character expression.

Syntax

right(expression, integer_expr)

Parameters

expression – is a character or binary-type column name, variable, or constant expression of char, varchar, nchar, unichar, nvarchar, univarchar, binary, or varbinary type.
integer_expr – is any integer (tinyint, smallint, or int) column name, variable, or constant expression.

Examples

Example 1 – Returns the part of "abcde" starting at three characters from the right:
```
select right("abcde", 3)
```
```
 ---
 cde
```
Example 2 – Returns the part of "abcde" starting at two characters from the right:
```
select right("abcde", 2)
```
```
 --
 de
```
Example 3 – Returns the part of "abcde" starting at six characters from the right:
```
select right("abcde", 6)
```
```
 -----
 abcde 
```
Example 4 – Returns the part of "0x12345000" starting at three characters from the right:
```
select right(0x12345000, 3)
```
```
 -------
 0x345000
```
Example 5 – Returns the part of "0x12345000" starting at two characters from the right:
```
select right(0x12345000, 2)
```
```
 ------
 0x5000
```
Example 6 – Returns the part of "0x12345000" starting at six characters from the right:
```
select right(0x12345000, 6)
```
```
 ---------
 0x12345000
```

Usage

right, a string function, returns the specified number of characters from the rightmost part of the character or binary expression.
If the specified rightmost part begins with the second surrogate of a pair (the low surrogate), the return value starts with the next full character. Therefore, one less character is returned.
The return value has the same datatype as the character or binary expression.
If expression is NULL, right returns NULL.

Standards

ANSI SQL – Compliance level: Transact-SQL extension

Permissions

Any user can execute right.