INITCAP

Purpose

This function returns the specified string, with the first letter of each word in uppercase, all other letters is lowercase. Words are delimited by white spaces or characters that are not alphanumeric.

Syntax

initcap::=

Example

SELECT INITCAP('ExAsOl is great') INITCAP;