Right

<< Click to Display Table of Contents >>

Navigation:  Apollo SQL > String Functions >

Right

Returns the rightmost Count characters contained in a string.

Syntax:

Right( 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 Right( LAST, 2 ) = 'son'