SQL · String functions

initcap()

Capitalises each word. PostgreSQL only.

sqlRunnable example sql course

Syntax

initcap(text)

Example

Open in the lab

-- PostgreSQL
-- SELECT initcap('hello world');

Reference pages are the quick answer. The course explains the why, shows the full example and ends with a challenge.