MS Access: Left Function


The syntax for the Left function in MS Access is:

Left ( text, number_of_characters )

Parameters or Arguments


The string that you wish to extract from.


Indicates the number of characters that you wish to extract starting from the left-most character.

Note If number_of_characters exceeds the number of characters in text, the Left function will return text.


Let’s look at how to use the Left function in MS Access:

Left (“Tech on the Net”, 4)

Result: “Tech”

Left (“Alphabet Soup”, 5)

Result: “Alpha”Left (“Alphabet”, 20)

Result: “Alphabet”

Source: MS Access: Left Function

This entry was posted in Compus and tagged , , , . Bookmark the permalink.