THE WORLD'S LARGEST WEB DEVELOPER SITE

MS Access Right() Function

❮ MS Access Functions

Example

Extract 4 characters from a string (starting from right):

SELECT Right("SQL Tutorial is cool", 4) AS ExtractString;
Try it Yourself »

Definition and Usage

The Right() function extracts a number of characters from a string (starting from right).

Note: See also the Left() function.

Syntax

Right(string, number_of_chars)

Parameter Values

Parameter Description
string Required. The string to extract from
number_of_chars Required. The number of characters to extract. If this parameter is higher than the number of characters in string, this function will return the entire string

Technical Details

Works in: From Access 2000

More Examples

Example

Extract 5 characters from the text in the "CustomerName" column (starting from right):

SELECT Right(CustomerName, 5) AS ExtractString
FROM Customers;
Try it Yourself »

❮ MS Access Functions