<< Click to Display Table of Contents >> Navigation: Apollo SQL > String Functions > Left |
Returns the leftmost Count characters contained in a string.
Syntax:
Left( Col_Name: String, Count:integer ): String
Col_Name is a string-type expression. Count is an integer expression. If Count is larger than S, then S is returned.
Example:
SELECT * FROM test WHERE Left( LAST, 1 ) = 'S'