Does Vertica have a mixed case string format function?

Vertica has functions to format text in upper and lower case, such as UPPER() and LOWER(). 

But I dont see any function for setting text to mixed case, so I can get "Visa", not "VISA" or "visa". 

Is mixed case formatting possible in the select line?


  • Options

    I think the INITCAP and INITCAPB functions should cover this.

    vap=> select 'visa';
    (1 row)

    vap=> select initcap('visa');
    (1 row)

    They can be found in the SQL Reference, SQL Functions, String Functions section of the docs.

Leave a Comment

BoldItalicStrikethroughOrdered listUnordered list
Align leftAlign centerAlign rightToggle HTML viewToggle full pageToggle lights
Drop image/file