|
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.
|
ExamplesThe
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.
|
|
|
|
