Using Case-Insensitive Search Functions (IDS)

The SQL search functions UPPER, LOWER, and INITCAP support GLS. They accept multibyte characters in character-type source strings and operate on them. The returned data type is the same as the type of the source string:

• UPPER converts every letter in a string to uppercase.
• LOWER converts every letter in a string to lowercase.
• INITCAP changes the first letter of a word or series of words to uppercase.

For complete information about these search functions, see the IBM Informix: Guide to SQL Syntax.