DataMigrator > Simplified Character Functions > INITCAP: Capitalizing the First Letter of Each Word in a String

INITCAP: Capitalizing the First Letter of Each Word in a String

How to:

INITCAP capitalizes the first letter of each word in an input string and makes all other letters lowercase. A word starts at the beginning of the string, after a blank space, or after a special character.

Syntax: How to Capitalize the First Letter of Each Word in a String 

INITCAP(input_string)

where:

input_string

Alphanumeric

Is the string to capitalize.

Example: Capitalizing the First Letter of Each Word in a String

INITCAP capitalizes the first letter of each word.

INITCAP(NewName)

For the string abc,def!ghi'jKL MNO, the result is Abc,Def!Ghi'Jkl Mno.

For MCKNIGHT, the result is Mcknight.

 WebFOCUS

Feedback