Upper

<< Click to Display Table of Contents >>

Navigation:  Apollo SQL > String Functions >

Upper

Returns a string containing the same text as S, but with all 7-bit ASCII characters between 'a' and 'z' converted to uppercase.

Syntax:

Upper( Col_Name: String ): String

Example:

SELECT * FROM test WHERE Upper(Last) = 'SMITH'

See Also

Lower