[<<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