Progress
SQL-92
Guide and Reference
LEFT Function
Returns the leftmost count of characters of string_exp.
SYNTAX
EXAMPLE
The following example shows how to use the LEFT function:
NOTES
string_exp
can be fixed-length or variable-length CHARACTER data types.count
can be INTEGER, SMALLINT, or TINYINT data types.- If any of the arguments of the expression evaluate to null, the result is null.
- If the
count
is negative, the result evaluates to null.- The
string_exp
and the result may contain multi-byte characters. The function returns the number of characters.COMPATIBILITY
ODBC Compatible
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |