Tabular IQ
Back to Function Index

INITCAP()

Overview

INITCAP() (formerly PROPER()) converts a text to proper case: the first letter of each word in upper case and every other letter in lower case. Use it to tidy names, cities and titles that arrive all in capitals or all in lower case.

Function Format

INITCAP(string)

Return Value

INITCAP() returns a character string

Examples


INITCAP('apples')               = 'Apples'
INITCAP('apples and oranges')   = 'Apples And Oranges'
INITCAP('JOHN DOE')             = 'John Doe'

// A word starts after anything that is not a letter
INITCAP('mary-jane')            = 'Mary-Jane'
INITCAP('o''brien')             = 'O''Brien'
INITCAP('3rd street')           = '3Rd Street'

// Capitals inside a word are lowered too
INITCAP('McDONALD')             = 'Mcdonald'

INITCAP('')                     = ''
INITCAP(NULL)                   = NULL

Notes

  • A letter is put in upper case when it starts the text or follows a character that is not a letter: a space, a hyphen, an apostrophe, a digit. Every other letter is put in lower case.
  • Characters that are not letters are left as they are.
  • If the string is null, the result is null.
  • The function was formerly named PROPER(). Write INITCAP(), which reads the same everywhere a formula runs.
  • For all capitals or all lower case, use UPPER() or LOWER().

See Also