Left()
Returns the left part of a character string starting from the first character.
Syntax
Left(<cString>, <nCount>) --> cSubString
Arguments
<cString> --> is a character string from which to extract characters.
<nCount> --> is the number of characters to extract.
Returns
Left() returns the leftmost <nCount> characters of <cString> as a character string. If <nCount> is negative or zero, Left() returns a null/empty string (""). If <nCount> is larger than the length of the character string, Left() returns the entire string.
Description
Left() is a character function that returns a substring of a character string. Left() is also like Right() which returns a substring beginning with the last character in a string. Left(), Right(), and SubStr() are often used with both the AT() and RAT() functions to locate the first and/or last position of a substring before extracting it.
Examples
This example extracts the first five characters from the left of a string:
Left('JASON FRANKS', 5)
* Returns: 'JASON'
____________________________
Related Topics:
|