TITLE()

All functions > STRING > TITLE()

Returns the string with the first letter of each whitespace-delimited word in uppercase and the remaining letters in lowercase.

Signatures

Returns: Title-cased string

TITLE(string: VARCHAR) → VARCHAR

Notes

• Whitespace separates words; leading and trailing whitespace are trimmed first, and words in the result are separated by a single space
• Letters are adjusted per word; digits, punctuation, and symbols other than word boundaries typically remain in place
• TITLE('') is ''; if the input is NULL the result is NULL (use NULL(VARCHAR); bare NULL fails inference)
• INITCAP(...) is an alias for TITLE(...) and behaves the same

Aliases

• INITCAP

Examples

SELECT
    f1 := TITLE('hello world'), -- Two words
    f2 := TITLE('HELLO WORLD'), -- From all caps
    f3 := INITCAP('mixed CASE text'), -- INITCAP alias matches TITLE
    f4 := TITLE('café au lait'), -- Accented letters
    f5 := TITLE(NULL(VARCHAR)) -- NULL yields NULL
;