SQL Server RIGHT() Function

The SQL Server (Transact-SQL) RIGHT() function is used to extract a substring from a string, starting from the right-most character.

Syntax

RIGHT(string, number_of_chars)

Parameters

Return Value

Returns the substring extracted from specified string.

Example 1:

The example below shows the usage of RIGHT() function.

SELECT RIGHT('AlphaCodingSkills.com', 1);
Result: 'm'

SELECT RIGHT('AlphaCodingSkills.com', 4);
Result: '.com'

SELECT RIGHT('AlphaCodingSkills.com', 21);
Result: 'AlphaCodingSkills.com'

SELECT RIGHT('AlphaCodingSkills.com', 50);
Result: 'AlphaCodingSkills.com'

SELECT RIGHT('Alpha Coding Skills', 6);
Result: 'Skills'

Example 2:

Consider a database table called Employee with the following records:

In the query below, the RIGHT() function is used to exclude the country code from the PhoneNumber column records.

SELECT *, RIGHT(PhoneNumber, LEN(PhoneNumber) - 4) AS ContactNumber 
FROM Employee;

This will produce the result as shown below: