Previous Topic Next topic Print topic

Micro Focus Enterprise Developer 3.0 for Eclipse > Programming > Mainframe Programming > SQL Option for DB2 > Reference > SQL Reference > Functions Overview > String Functions > INITCAP

INITCAP

Restriction: This topic applies to Windows environments only.
ANSI DB2 SQL/DS XDB
      X

Capitalizes the first character of each word and makes the rest of each word lower case. The format appears below:

INITCAP(charexpr)

For example:

INITCAP("xdb SYSTEMS") = "Xdb Systems"
Parent topic: String Functions
Previous Topic Next topic Print topic