THE WORLD'S LARGEST WEB DEVELOPER SITE

MS Access Left() Function

❮ MS Access Functions

Example

Extract 3 characters from a string (starting from left):

SELECT Left("SQL Tutorial", 3) AS ExtractString;
Try it Yourself »

Definition and Usage

The Left() function extracts a number of characters from a string (starting from left).

Note: See also the Right() function.

Syntax

Left(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 left):

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

❮ MS Access Functions