The INITCAP function returns a string with the first character of each word converted to uppercase, using the UPPER function semantics, and the other characters converted to lowercase, using the LOWER function semantics.

The schema is SYSIBM.

Table 1. Word delimiter characters

Note:

A character listed in the preceding table might not have an allocated code point in a particular database code page.

string-expression

An expression that returns a CHAR or VARCHAR data type.
In a Unicode database, the expression can return a GRAPHIC or VARGRAPHIC data type.

The data type of the result depends on the data type of string-expression, as described in the following table:

Table 2. Data type of string-expression compared to the data type of the result

The length attribute of the result is the same as the length attribute of string-expression.

If the argument can be null, the result can be null; if the argument is null, the result is the null value.

Examples

1. Input the string a prospective book title to return the string A Prospective Book Title.

      VALUES INITCAP ('a prospective book title')
      1 
      ------------------------
      A Prospective Book Title  

2. Input the string YOUR NAME to return the string Your Name.

      VALUES INITCAP ('YOUR NAME') 
      1 
      ---------
      Your Name  

3. Input the string my_résumé to return the string My_Résumé.

      VALUES INITCAP ('my_résumé')
      1 
      --------- 
      My_Résumé

4. Input the string élégant to return the string Élégant.

      VALUES INITCAP ('FORMAT:élégant')  
      1 
      -------------- 
      Format:Élégant