4.9.2.36 INITCAP function (extension)

Syntax

INITCAP ( char_expression )

Description

The scalar function INITCAP returns the result of the argument character expression after converting the first character to upper case and the subsequent characters to lower case.

Example

SELECT INITCAP (name)
     FROM  customer ;

Notes

• The argument to the function must be of type CHARACTER.
• The result is of type CHARACTER.
• If the argument expression evaluates to null, the result is null.