|
Extracts a specified number of
characters from a string, starting with the first character on the
left.
Parameters
|
Parameter
|
Description
|
|
s
|
The string to extract from.
|
|
n
|
The number of characters to extract.
If
the number of characters to extract is greater than the length of
the string, the function returns the whole string.
If the
number of characters to extract is 0 or less, the function returns
the empty string.
|
Examples
The
following expressions are examples that use the
Left
function:
|
Expression
|
Returns
|
|
Left("ABCDEFGH", 3)
|
ABC
|
|
Left("Tony Blue", 5)
|
"Tony "
|
|
Left(Telephone[0], 3)
|
The first three characters of the first
occurrence of
Telephone
.
|
|
Left(Rtrim(Last_Name), 3)
|
The first three characters of
Last_Name
.
See
also
Rtrim
.
|
|
|
|
