All Products
Search
Document Center

INITCAP

Last Updated: Jun 18, 2021

The INITCAP function returns a string where the initial letter of each word is in uppercase and the other letters are in lowercase.

Syntax

INITCAP(c1)

Parameters

Parameter

Description

c1

The string. The string type can be CHAR, VARCHAR2, NCHAR, or NVARCHAR2.

Return type

The data of the CHAR type is returned.

Examples

Execute the following statement:

SELECT initcap('smith abc aBC') upp FROM DUAL;

The following query result is returned:

+------------------+
|   UPP            |
+------------------+
|   Smith Abc Abc  |
+------------------+