INITCAPB

Capitalizes first letter of each alphanumeric word and puts the rest in lowercase. Multibyte characters are not converted and are skipped.

Behavior Type

Immutable

Syntax

INITCAPB ( expression ) 

Parameters

expression

(VARCHAR) is the string to format.

Notes

Depends on collation setting of the locale.

Examples

Expression

Result

SELECT INITCAPB('étudiant');
éTudiant
SELECT INITCAPB('high speed database');
High Speed Database
SELECT INITCAPB('LINUX TUTORIAL');
Linux Tutorial
SELECT INITCAPB('abc DEF 123aVC 124Btd,lAsT');
Abc Def 123Avc 124Btd,Last
SELECT INITCAPB('');

                            
SELECT INITCAPB(null);