[<<Previous Entry] [^^Up^^] [Next Entry>>] [Menu] [About The Guide]
RIGHT()

    Extracts a specified number of characters from the right of a
character string.

Syntax

    RIGHT<expC>,<expN>)

Argument

    <expC> is a character string from which to extract characters.

    <expN> is the number of characters to extract.

Returns

    A character string.

    RIGHT() returns the rightmost <expN> characters of <expC>.  If <expN>
is negative or zero, LEFT() returns a null string ("").  If <expN> is
larger than the length of the character string, LEFT() returns the
entire string.  The maximum size of <expC> is 65,535 (64K) bytes.

See Also: AT LTRIM RAT LEFT RTRIM SUBSTR
This page created by ng2html v1.05, the Norton guide to HTML conversion utility. Written by Dave Pearson