Microsoft Access Function Library: Left()

[bbasujon]

Function: Left()

Purpose: The Left() function returns the specified number of characters of a string, beginning with the leftmost character.

Usage: Left(string, n)

Returns: The leftmost n characters of the specified string.

Example:

Dim MyString() As String = {"Testing, Testing, 123"}
Dim ResultString As String = Left(MyString, 7)

In this example, ResultString would contain "Testing"