Right()

Returns the right portion of a character string.

Syntax

Right(<cString>, <nCount>) --> cSubString

Arguments

<cString> --> is the character string from which to extract characters.

<nCount> --> is the number of characters to extract from the right.

Returns

Right() returns the rightmost <nCount> characters of <cString>. If <nCount> is zero, Right() returns a null/empty string (""). If <nCount> is negative or larger than the length of the character string, Right() returns <cString>.

Description

Right() is a character function that extracts the right part of a character string. The Right(), Left(), and SubStr() functions are often used with both the AT() and RAT() functions to locate either the first and/or the last position of a substring before extracting it.

Examples

Right('John Smith', 5)

* Result = 'Smith'

____________________________