Returns the result of the argument character expression after converting the first character to uppercase and the subsequent characters to lowercase.

Syntax

INITCAP ( char_expression )

Notes

  • The char_expression must be of type CHARACTER.
  • The result is of type CHARACTER.
  • If the argument expression evaluates to NULL, the result is NULL.
  • A char_expression and the result can contain multi‑byte characters. The uppercase conversion for the first character and the lowercase conversion for the rest of the characters is based on the case table in the convmap file. The default case table is BASIC.

Example

The following example shows how to use the INITCAP function:

SELECT INITCAP (last_name) 
     FROM customer ;

Compatibility

Progress extension