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