<< Click to Display Table of Contents >> Navigation:  Apollo SQL > String Functions > Lower

Returns a string with the same text as the string passed in, but with all letters converted to lowercase.

Syntax:

Lower( Col_Name: String ): String

 

The conversion affects only 7-bit ASCII characters between 'A' and 'Z'.

Col_Name is a string-type expression.

Example:

SELECT * FROM test WHERE Lower( LAST) = 'smith'

See Also

Upper