INITCAP

Capitalizes first letter of each alphanumeric word and puts the rest in lowercase.

Behavior Type

Immutable

Syntax

INITCAP ( expression ) 

Parameters

expression

(VARCHAR) is the string to format.

Notes

Examples

Expression

Result

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