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