PostgreSQLString FunctionsINITCAP
SPLIT_PART

INITCAPString Functions

TO_CHAR

Converts the first letter of each word to uppercase.

Syntax

INITCAP(str)

Example

Enter values below to update the example in real time.

full_name
normalized_name
customers
SELECT INITCAP(LOWER(full_name)) AS normalized_name
FROM customers;