SQL Reference Guide

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 uppercase and the subsequent characters to lowercase.

Example

SELECT INITCAP (name)

FROM customer ;

Notes

• The argument to the function must be and of the character types.
• The result type is based on the argument type.
• If the argument expression evaluates to null, the result is null.