Author Topic: Microsoft Access Function Library: Left()  (Read 5083 times)

bbasujon

  • Administrator
  • VIP Member
  • *****
  • Posts: 1826
  • I want to show my performance at any where
    • View Profile
    • Higher Education
Microsoft Access Function Library: Left()
« on: August 15, 2012, 05:17:51 PM »
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"
Acquire the knowledge and share the knowledge so that knowing,learning then sharing - all are the collection