[<<Previous Entry]
[^^Up^^]
[Next Entry>>]
[Menu]
[About The Guide]
+---------------------------------+
| LEFT |
+---------------------------------+
LEFT(<expC>, <expN>)
-----------------------------------
Returns leftmost characters from a character expression.
Return value - Character
-----------------------------------
The LEFT() function returns a specified number of characters from a
character expression <expC>. The character expression may be a
character string, the name of a memo field or the name of a character
field.
The number of characters returned, starting with the leftmost character,
is specified by <expN>. If <expN> is greater than the length of <expC>,
the entire string is returned. If <expN> is less than or equal to 0,
the null string is returned.
The LEFT() function works the same as the SUBSTR() function with a
starting position of one (1).
Clauses
-------
<expC>
Character expression from which characters are to be returned.
<expN>
Number of characters to be returned.
+---------------------------------+
| Examples |
+---------------------------------+
? LEFT('Perrysburg, OH', 10)
-----------------------------------
See Also: AT(), LTRIM(), RTRIM(), RIGHT(), SUBSTR()
-----------------------------------
See Also:
AT()
LTRIM()
RTRIM()
RIGHT()
SUBSTR()
This page created by ng2html v1.05, the Norton guide to HTML conversion utility.
Written by Dave Pearson