Functions / String Functions And Operators

initcap

Converts the first letter of each word to upper case and the rest to lower case.

Reading PG 18current·documented in 27 of 27 versions, 7.1 to 20

7.1 7.2 7.3 7.4 8.0 8.1 8.2 8.3 8.4 9.0 9.1 9.2 9.3 9.4 9.5 9.6 10 11 12 13 14 15 16 17 18 19 20

Signatures & examples

initcap ( text ) → text

Converts the first letter of each word to upper case and the rest to lower case. Words are sequences of alphanumeric characters separated by non-alphanumeric characters.

initcap('hi THOMAS') → Hi Thomas

Version history 7

18 → 19 changed
12 → 13 changed
8.4 → 9.0 changed
8.1 → 8.2 changed
7.4 → 8.0 changed
7.3 → 7.4 changed
7.2 → 7.3 changed

Definition snapshot: b7bd9cda · English manual source