MS Access: Left Function

Syntax

The syntax for the Left function in MS Access is:

Left ( text, number_of_characters )

Parameters or Arguments

text

The string that you wish to extract from.

number_of_characters

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.

Example

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

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