[<<Previous Entry] [^^Up^^] [Next Entry>>] [Menu] [About The Guide]
+---------------------------------+
|             SUBSTR              |
+---------------------------------+
SUBSTR(<expC>, <expN1> [, <expN2>])

-----------------------------------
Returns specified number of characters from character expression.
Return value - Character
-----------------------------------

This function extracts characters from a character expression, starting
at specified position in  character expression and continuing for
specified number of characters.

<expC>
        Character expression (including memo field) from which characters are
extracted.

<expN1>
        Position in character expression <expC> where character extraction
begins.  First character of <expC> is position 1.

<expN2>
        Specifies number of characters to be extracted from character
expression.   If <expN2> is omitted, then characters are extracted until
the end of the expression is reached.

-----------------------------------

See Also:  AT(), LEFT(), RAT(), RIGHT(), STRTRAN(), STUFF()

-----------------------------------

See Also: AT() LEFT() RAT() RIGHT() STRTRAN() STUFF()
This page created by ng2html v1.05, the Norton guide to HTML conversion utility. Written by Dave Pearson