Syntax

Left[$](string, length)

LeftB[$](string,length)

Description

Functions return the leftmost length characters as follows.

Functions

Return the leftmost length characters

Left and Left$

Of bytes

LeftB and LeftB$

From a given string

Left$ and Left functions return the following.

Function

Returns

Left$

String

Left

String variant.

The length parameter is an Integer value specifying the number of characters to return as follows.

Length is

Returns

0

Zero-length string

Greater than or equal to the number of characters in the specified string

Entire string

LeftB and LeftB$ functions return the following.

Functions

Return

LeftB and LeftB$

Sequence of bytes from a string containing byte data.

length specifies the number of bytes to return as follows.

Length is

Returns

Greater than the number of bytes in string

Entire string

String is Null.

Null

Comments

Left$ returns a String, whereas Left returns a String variant.

NumChars is an Integer value specifying the number of character to return. If NumChars is 0, then a zero-length string is returned. If NumChars is greater than or equal to the number of characters in the specified string, then the entire string is returned.

NULL is returned if text is NULL.

Example

This example shows the Left$ function used to change uppercase names to lowercase with an uppercase first letter.

Sub Main()
  lname$ = "WILLIAMS"
  fl$ = Left(lname$,1)
  rest$ = Mid(lname$,2,Len(lname$))
  lname$ = fl$ & LCase(rest$)
  MsgBox "The converted name is: " & lname$
End Sub

See Also

Right, Right$, RightB, RightB$ (functions)

L