Progress
SQL-92
Guide and Reference


LEFT Function

Returns the leftmost count of characters of string_exp.

SYNTAX

LEFT ( string_exp , count ) 

EXAMPLE

The following example shows how to use the LEFT function:

SELECT LEFT(last_name,4) FROM  customer WHERE last_name = ’Goldman’;
 
LEFT(LAST_NAME),4)
------------------
Gold
 
1 record selected 

NOTES

COMPATIBILITY

ODBC Compatible


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095