Left

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