INITCAP

Description

Capitalizes the first letter of the word contained in the parameter and converts the rest of the letters to lowercase. A word is a sequence of alphanumeric characters separated by non-alphanumeric characters.

Syntax

INITCAP ( <str> )

Parameters

Parameter	Description
<str>	The string to be converted

Return Value

The result of capitalizing the first letter of the word in the parameter <str> and lowering the rest of the letters.

Example

SELECT INITCAP('hello hello.,HELLO123HELlo')

+---------------------------------------+
| initcap('hello hello.,HELLO123HELlo') |
+---------------------------------------+
| Hello Hello.,hello123hello            |
+---------------------------------------+